[Pgcluster-general] Connection to load balancer refused

[Peter Vallero]

I have installed pgcluster-1.7.0rc7.patch on Postgres 8.2.4, and configured it with 1 load balancer, 2 cluster databases, and 2 replication servers, thus:

    db01
        pglb (listening on port 5433)
        cluster db 1 (listening on port 5434)
        replication server 1

    db02
        cluster db 2 (listening on port 5434)
        replication server 2


Replication is working fine:  I can connect to each cluster db and I have verified that changes to each are replicated to the other.

And when I connect from db01 through the load balancer, I do connect to one of the databases:  I can issue queries, and I see traffic in the pglb log.

However, when I try to connect from db02 or from any other machine (with either psql or JDBC), I get:

    psql: could not connect to server: Connection refused
            Is the server running on host "jack-db01.jacked.com" and accepting
            TCP/IP connections on port 5433?


I can provide all of my configuration information if necessary, although I essentially followed the instructions on http://pgcluster.projects.postgresql.org/1_3/pglb_conf.html closely.

Thanks,

Peter Vallero
pjvallero at yahoo.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgcluster-general/attachments/20070830/2f0fc9d1/attachment.html