You also did not state which O/S you are working with or which version of PostgreSQL you are using. In either case, you still need to update the pg_hba.conf file and then reload.
http://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html On Fri, Jun 12, 2015 at 11:32 AM, Mephysto <mephystoonh...@gmail.com> wrote: > 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. >> > > -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
