Re: PostgreSQL and iptables

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 <melvin6925(at)gmail(dot)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 <mephystoonhell(at)gmail(dot)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(at)postgresql(dot)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.
>