> -----Original Message----- > From: pgpool-general-boun...@pgfoundry.org [mailto:pgpool-general- > boun...@pgfoundry.org] On Behalf Of Alan Hodgson > Sent: Thursday, October 06, 2011 5:52 PM > To: pgpool-general@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@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 _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general