Re: Server not listening

>-----Original Message-----
>From: pgadmin-support-owner(at)postgresql(dot)org
>[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of
>Raymond O'Donnell
>Sent: woensdag 18 april 2007 10:41
>To: GeorgeHeller
>Cc: pgadmin-support(at)postgresql(dot)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