[Pgpool-general] Setting up PGpool with PostgreSQL 9.0

Matthew Bennett mbennett at privateersoftware.com
Thu Jan 20 22:58:45 UTC 2011


I am setting up PGpool with PostgreSQL 9.0 using streaming replication. I want
to use PGpool to load balance between the live database and the hot-standby. The
two Postgres servers are running on their own machines and PGpool is running on
it's own server. I think I have everything set up correctly.

On the PGpool machine, I try to run: psql -p 9999 

I get the following error:

psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.9999"?

I can run all of the pcp commands except for pcp_systemdb_info where I get the
EOFError.

There must be something simple that I have missed.



More information about the Pgpool-general mailing list