Re: PostgreSQL and iptables

From: Melvin Davidson <melvin6925(at)gmail(dot)com>
To: Mephysto <mephystoonhell(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL and iptables
Date: 2015-06-12 15:37:19
Message-ID: CANu8Fiy6escvGe9af+1YrsGnSN-g6xDpXXoJ0PByVqpSTO2XJA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Holger.Friedrich-Fa-Trivadis 2015-06-12 15:37:35 FW: PostgreSQL and iptables
Previous Message Mephysto 2015-06-12 15:32:02 Re: PostgreSQL and iptables