I am sorry, I forgot to say that port of my database in postgresql.conf is setted to 5997.
Byem Meph On 12 June 2015 at 17:10, Melvin Davidson <melvin6...@gmail.com> wrote: > 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. >
