[Pgpool-general] How to configure pgpool for pool conexions..

[Daniel.Crespo at l-3com.com]

> -----Original Message-----
> From: pgpool-general-bounces at pgfoundry.org [mailto:pgpool-general-
> bounces at pgfoundry.org] On Behalf Of Alan Hodgson
> Sent: Thursday, October 06, 2011 5:52 PM
> To: pgpool-general at pgfoundry.org
> Subject: Re: [Pgpool-general] How to configure pgpool for pool
> conexions..
> 
> On October 6, 2011 02:44:34 PM Matias Israel Malpica Escobar wrote:
> > Another question for you guys...
> >
> > I have succesfully installed and configure pgpool, if i go to
pgadmin
> > and connect to port 9999 of my server i can see the databases and
> > everything... but when i try to run the following i get this error:
> >
> > [root at etc]# psql -d test -U testuser -p 9999
> > psql: could not connect to server: Connection refused
> >         Is the server running locally and accepting
> >         connections on Unix domain socket "/tmp/.s.PGSQL.9999"?
> > [root@ etc]#
> 
> What is socket_dir set to in pgpool.conf? If it isn't /tmp, then psql
> will
> need a hint how to find the unix domain socket to talk to.

First, check that you can connect to the database by doing:
psql -U postgres -h localhost -p 5432
(assuming proper postgresql.conf entries, like -> listen_addresses =
'*')

If it succeeds, then, in pgpool.conf, check that backend_hostname0 is
pointing to where the database is. If it's localhost, the following
should most likely be in your pgpool configuration:
backend_hostname0 = 'localhost'
backend_port0 = 5432
backend_weight0 = 0
backend_data_directory0 = '/var/lib/pgsql/9.0/data'

Restart pgpool and try again connecting to the database through pgpool
by doing:
psql -U postgres -p 9999

If it doesn't work. Stop pgpool, and run it with debug output by doing
the following as root:

pgpool -n -d

It should tell you that it cannot connect to backend0 for a reason. Then
come back and show us your findings.

-Daniel