>-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of >Raymond O'Donnell >Sent: woensdag 18 april 2007 10:41 >To: GeorgeHeller >Cc: pgadmin-support@postgresql.org >Subject: Re: [pgadmin-support] Server not listening > >On 18/04/2007 03:32, GeorgeHeller wrote: > >> The server doesn't accept connections: the connection >library reports >> could not connect to server: Connection refused >(0x0000274D/10061) Is >> the server running on host "192.212.105.111" and accepting TCP/IP >> connections on port 5432? > >Are you sure the server *is* actually running? - Have you >tried to connect to it with something else, such as psql? - or >do a "ps ax | grep postgres" on the server machine and >verified that it's there?
If this doesn't resolve the problem, check the server is actually listening at the socket. You should verify that your postgresql.conf file has the correct settings. The "listen_addresses" configuration parameter should be set correctly. Changing this requires you to restart postgres for the changes to take effect. Having listen_addresses = '*' port = 5432 in the postgresql.conf file generally works. (Don't forget to restart (NOT reload, but restart) the postgresql server. See also <http://www.postgresql.org/docs/8.2/interactive/runtime-config-connectio n.html#RUNTIME-CONFIG-CONNECTION-SETTINGS> If this fails, check that no firewall is blocking the communication. - Joris ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
