Re: Server not listening - Mailing list pgadmin-support

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@postgresql.org 
>>[mailto:pgadmin-support-owner@postgresql.org] 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
> 
> 

-- 
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.