The default port for PostgreSQL is 5432. To allow external ip access, you need to specifcally add the ip's to the pg_hba.conf on the PostgreSQL server and then reload the PostgreSQL cluster. IE: pg_ctl reload
On Fri, Jun 12, 2015 at 10:58 AM, mephysto <mephystoonh...@gmail.com> wrote: > Hi there, > I am trying to install a postgres cluster in a XenSever VM: I did not have > any difficulties in compiling, installing and starting the DB. The problem > is that I can not access to this db from an external machine: I tried to > configure port forwarding through iptables as well as I did for ssh > connections (ssh is working correctly). > > Actually I do not have psql in XenServer host, I am using a third server > and > this is iptables rules I am trying: > > iptables -t nat -A PREROUTING -p tcp --dport 5997 -j DNAT --to-destination > 10.0.0.4:5997 > > > I also triet do scan port by nmap and I received this output: > > nmap -p 5997 pippo.eu > > Starting Nmap 5.00 ( http://nmap.org ) at 2015-06-12 16:38 CEST > Interesting ports on pippo.eu (xxx.xxx.xxx.xxx): > PORT STATE SERVICE > 5997/tcp filtered ncd-pref > > > > > This is psql output: > > psql -p 5997 -h pippo.eu > psql: could not connect to server: No route to host > Is the server running on host "pippo.eu" (xxx.xxx.xxx.xxx) and > accepting > TCP/IP connections on port 5997? > > > Port 5997 is open in virtual machine and accept connections. > > > Can anyone help me? I'm going crazy.... :( > > Thanks in advance. > > Meph > > > > -- > View this message in context: > http://postgresql.nabble.com/PostgreSQL-and-iptables-tp5853587.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.