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 serverOn Fri, Jun 12, 2015 at 10:58 AM, mephysto <mephystoonhell@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
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.![]()
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
