Re: Postgres does not accept socket connections

"A. Kretschmer" <andreas.kretschmer@schollglas.com> writes:
> am  02.03.2006, um  4:37:02 -0800 mailte kishore.sainath@gmail.com folgendes:
>> psql: could not connect to server: Connection refused
>> Is the server running on host "server-name" and accepting
>> TCP/IP connections on port 5432?

> Check the postgresql.conf for the value "listen_addresses".
> My guess: listen_address is at the moment 'localhost'. Change this to
> the LAN-address or '*'.

If listen_addresses is correct and you still get "Connection refused",
the other thing to look at is the kernel's packet filtering rules
(iptables).  I believe the default configuration on FC4 will reject
external connections to 5432.

            regards, tom lane