Re: Server not listening

I have checked that the server is listening, I am able to ping it from my
computer, and the ps ax|grep postgres command gives me,

20058 ? S 0:00 /usr/local/pgsql/bin/postgres
20060 ? Ss 0:00 postgres: writer process
20061 ? Ss 0:00 postgres: stats collector process
20653 pts/1 S+ 0:00 grep postgres

I have changed the postgresql.conf file to have listen_addresses='*' and
port=5432, and have restarted the server.

I still seem to be getting the problem..

George

Joris Dobbelsteen-2 wrote:
>
>>-----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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>
>

--
View this message in context: http://www.nabble.com/Server-not-listening-tf3598646.html#a10066443
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.