Re: client connection problem - Mailing list pgsql-admin

From Tom Lane
Subject Re: client connection problem
Date
Msg-id 9403.1011196316@sss.pgh.pa.us
Whole thread Raw
In response to Re: client connection problem  ("Nick Fankhauser" <nickf@ontko.com>)
List pgsql-admin
"Nick Fankhauser" <nickf@ontko.com> writes:
> Try adding a line to pg_hba.conf for localhost specifically- I'd guess that
> the request is coming in with that address rather than the local machine's
> IP address.

Another possibility is that the connection request is being dropped on
the floor by kernel packet filtering.  The default filtering in RH 7.2
is pretty aggressive (just the other day I had to change quite a few
things to get it to allow incoming and outgoing NFS, for example).
Check your ipchains setup in /etc/sysconfig/ipchains.

IIRC, the default ipchains setup does *not* filter localhost
connections, but I think it would apply to connections showing a source
address of your Ethernet IP.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: client connection problem
Next
From: Tom Lane
Date:
Subject: Re: problems with pg_dump/pg_restore