[Pgpool-general] Setting up PGpool with PostgreSQL 9.0

[Guillaume Lelarge]

Le 20/01/2011 23:58, Matthew Bennett a écrit :
> 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.
> 

Can you show us your pgpool.conf file?


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com