Re: open port 5432 for postgres

Ansgar -59cobalt- Wiechers wrote:
> renz wrote:
> > NO, pgAdmin is not on the same host.
>
> Care to provide some details on the network? Which host is running
> pgAdmin, which host is running iptables, and which one is running
> postgres?

host running pgAdmin is a Windows 2003 SBS server, and host running
iptables and postgres is a Fedora Core release 3 (Heidelberg) Kernel
2.6.9-1.667 on an i686
...I'm trying to setup a BACKUP postgres server in case the current one
goes down.

>
> > 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
>
> Which options did you use for this scan? Is postgres even running on the
> host you scanned? What's the output of "netstat -ntl" on that host?

I didn't use any options.
Yes, postgres is running on this host.
output of netstat -ntl:

Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address
Stat e
tcp 0 0 0.0.0.0:32769 0.0.0.0:*
LIST EN
tcp 0 0 0.0.0.0:37 0.0.0.0:*
LIST EN
tcp 0 0 0.0.0.0:111 0.0.0.0:*
LIST EN
tcp 0 0 127.0.0.1:5432 0.0.0.0:*
LIST EN
tcp 0 0 127.0.0.1:25 0.0.0.0:*
LIST EN
tcp 0 0 :::22 :::*
LIST EN
                           renz
>
> cu
> 59cobalt
> --
> "Another option [for defragmentation] is to back up your important files,
> erase the hard disk, then reinstall Mac OS X and your backed up files."
> --http://docs.info.apple.com/article.html?artnum=25668
Received on Sat Dec 3 04:18:16 2005