Re: open port 5432 for postgres

jKILLSPAM.schipper@math.uu.nl wrote:
> Wolfgang Kueter <wolfgang@shconnect.de> wrote:
> > Am Tue, 22 Nov 2005 13:59:32 -0800 schrieb renz:
> >
> >> I need to know how to open up port 5432 using iptables to allow me to
> >> connect to our postgres server (Fedora Linux) with pgAdmin.
> >
> > Just like allowing any other tcp connection to whatever port when using
> > iptables.
> >
> > man iptables
> >
> > and maybe concerning pg_hba.conf:
> >
> > http://www.schwer.us/nblug/dba/postgresql.html#secure
> >
> > Wolfgang
>
> Do note, though, that if pgAdmin is on the same host, no port needs to
> be opened. Unless you are paranoid enough to filter loopback...
>
> Joachim

NO, pgAdmin is not on the same host.

I added these to my iptables, applied the rule, then restarted
iptables:

iptables -A INPUT -p tcp --source 192.168.1.0/24 --syn --dport 5432 -j
ACCEPT
iptables -A INPUT -p udp --source 192.168.1.0/24 --dport 5432 -j
ACCEPT

but when I ran nmap to check, this is the result I get:

PORT STATE SERVICE
22/tcp open ssh
37/tcp open time
111/tcp open rpcbind

                         renz
Received on Sat Dec 3 04:18:01 2005