Re: Postgres does not accept socket connections - Mailing list pgsql-general

From Tom Lane
Subject Re: Postgres does not accept socket connections
Date
Msg-id 3107.1141314551@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres does not accept socket connections  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Thread scheduling in postgresql 8.1.3 on windows
Next
From: Anakreon Mendis
Date:
Subject: Insert fails when it shouldn't