Re: client connection problem - Mailing list pgsql-admin

From Rasmus Mohr
Subject Re: client connection problem
Date
Msg-id 910513A5A944D5118BE900C04F67CB5A0BFD03@MAIL
Whole thread Raw
In response to client connection problem  (Rasmus Mohr <rmo@Netpointers.com>)
List pgsql-admin
Bullseye! Packet filtering was the problem, and was solved by allowing
packets destined to port 5432 in ipchains.

thanx a lot!

-----Oprindelig meddelelse-----
Fra: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]På vegne af Tom Lane
Sendt: 16. januar 2002 16:52
Til: nickf@ontko.com
Cc: Rasmus Mohr; pgsql-admin@postgresql.org
Emne: Re: [ADMIN] client connection problem


"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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


pgsql-admin by date:

Previous
From: Jean-Michel POURE
Date:
Subject: CREATE OR REPLACE VIEW / TRIGGER
Next
From: "omid omoomi"
Date:
Subject: Re: finding file names