Обсуждение: psql remote database access

Поиск
Список
Период
Сортировка

psql remote database access

От
Ron Watkins
Дата:

Im sure this has been addressed somewhere, but I wasn’t able to locate any answers.

I have a postgres database running on a different host and I need to access it remotely from another box.

 

Boxes are CentOS 6, and I opened the firewall port 5432 on the database server host.

Also, on the database server host, I made the following entries to /var/lib/pgsql/9.6/data/pg_hba.conf.

local   all             all                                     md5

host    all             all             127.0.0.1/32            md5

host    all             all             10.42.42.16/24          md5

 

When I try to use psql to attach to the remote database, I get the following error:

[root@host1 ~]# psql -h host2 -p 5432 -U postgres

psql: FATAL:  no pg_hba.conf entry for host "10.0.0.254", user "postgres", database "postgres", SSL off

Re: psql remote database access

От
Samed YILDIRIM
Дата:
<div>Hi,</div><div> </div><div>It is written on error log of psql. Postgres service sees your IP as 10.0.0.254, not
10.42.42.16.Most probably there is a NAT between your box and Postgres service. You should add following entry to
pg_hba.confand restart Postgres.</div><div> </div><div><span style="font-size:8pt;font-family:"Courier New";">host   
all            all             10.0.0.254/32          md5</span></div><div> </div><div>Best
regards.</div><div> </div><div><br/></div><div><br /></div><div>İyi çalışmalar.</div><div>Samed YILDIRIM</div><div><br
/></div><div><br/></div><div><br /></div><div>10.11.2016, 15:47, "Ron Watkins"
<rwatkins@dssolutions.com>:</div><blockquotetype="cite"><div lang="EN-US" link="blue" vlink="purple"><div><p>Im
surethis has been addressed somewhere, but I wasn’t able to locate any answers.<p>I have a postgres database running on
adifferent host and I need to access it remotely from another box.<p> <p>Boxes are CentOS 6, and I opened the firewall
port5432 on the database server host.<p>Also, on the database server host, I made the following entries to <span
style="font-size:8pt;font-family:"CourierNew";">/var/lib/pgsql/9.6/data/pg_hba.conf.</span><p><span
style="font-size:8pt;font-family:"CourierNew";">local   all             all                                    
md5</span><p><spanstyle="font-size:8pt;font-family:"Courier New";">host    all             all             <a
href="http://127.0.0.1/32">127.0.0.1/32</a>           md5</span><p><span style="font-size:8pt;font-family:"Courier
New";">host   all             all             <a href="http://10.42.42.16/24">10.42.42.16/24</a>         
md5</span><p><spanstyle="font-size:8pt;font-family:"Courier New";"> </span><p>When I try to use psql to attach to the
remotedatabase, I get the following error: <p><span style="font-size:8pt;font-family:"Courier New";">[root@host1 ~]#
psql-h host2 -p 5432 -U postgres</span><p><span style="font-size:8pt;font-family:"Courier New";">psql: FATAL:  no
pg_hba.confentry for host "10.0.0.254", user "postgres", database "postgres", SSL off</span></div></div></blockquote> 

Re: psql remote database access

От
Samed YILDIRIM
Дата:
<div>Sorry, reloading of postgres is enough for pg_hba.conf changes.</div><div><br /></div><div><br /></div><div>İyi
çalışmalar.</div><div>SamedYILDIRIM</div><div><br /></div><div><br /></div><div><br /></div><div>10.11.2016, 15:53,
"SamedYILDIRIM" <samed@reddoc.net>:</div><blockquote type="cite"><div>Hi,</div><div> </div><div>It is written on
errorlog of psql. Postgres service sees your IP as 10.0.0.254, not 10.42.42.16. Most probably there is a NAT between
yourbox and Postgres service. You should add following entry to pg_hba.conf and restart
Postgres.</div><div> </div><div><spanstyle="font-size:8pt;font-family:"Courier New";">host    all            
all            10.0.0.254/32          md5</span></div><div> </div><div>Best regards.</div><div> </div><div><br
/></div><div><br/></div><div>İyi çalışmalar.</div><div>Samed YILDIRIM</div><div><br /></div><div><br /></div><div><br
/></div><div>10.11.2016,15:47, "Ron Watkins" <<a
href="mailto:rwatkins@dssolutions.com">rwatkins@dssolutions.com</a>>:</div><blockquotetype="cite"><div lang="EN-US"
link="blue"vlink="purple"><div><p>Im sure this has been addressed somewhere, but I wasn’t able to locate any
answers.<p>Ihave a postgres database running on a different host and I need to access it remotely from another
box.<p> <p>Boxesare CentOS 6, and I opened the firewall port 5432 on the database server host.<p>Also, on the database
serverhost, I made the following entries to <span style="font-size:8pt;font-family:"Courier
New";">/var/lib/pgsql/9.6/data/pg_hba.conf.</span><p><spanstyle="font-size:8pt;font-family:"Courier New";">local  
all            all                                     md5</span><p><span style="font-size:8pt;font-family:"Courier
New";">host   all             all             <a href="http://127.0.0.1/32">127.0.0.1/32</a>           
md5</span><p><spanstyle="font-size:8pt;font-family:"Courier New";">host    all             all             <a
href="http://10.42.42.16/24">10.42.42.16/24</a>         md5</span><p><span style="font-size:8pt;font-family:"Courier
New";"> </span><p>WhenI try to use psql to attach to the remote database, I get the following error: <p><span
style="font-size:8pt;font-family:"CourierNew";">[root@host1 ~]# psql -h host2 -p 5432 -U postgres</span><p><span
style="font-size:8pt;font-family:"CourierNew";">psql: FATAL:  no pg_hba.conf entry for host "10.0.0.254", user
"postgres",database "postgres", SSL off</span></div></div></blockquote></blockquote> 

Re: psql remote database access

От
"Ron Watkins"
Дата:

Yes, that worked. Just had to restart server process, now it’s working.

 

From: Samed YILDIRIM [mailto:samed@reddoc.net]
Sent: Thursday, November 10, 2016 6:58 AM
To: Ron Watkins; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] psql remote database access

 

Sorry, reloading of postgres is enough for pg_hba.conf changes.

 

 

İyi çalışmalar.

Samed YILDIRIM

 

 

 

10.11.2016, 15:53, "Samed YILDIRIM" <samed@reddoc.net>:

Hi,

 

It is written on error log of psql. Postgres service sees your IP as 10.0.0.254, not 10.42.42.16. Most probably there is a NAT between your box and Postgres service. You should add following entry to pg_hba.conf and restart Postgres.

 

host    all             all             10.0.0.254/32          md5

 

Best regards.

 

 

 

İyi çalışmalar.

Samed YILDIRIM

 

 

 

10.11.2016, 15:47, "Ron Watkins" <rwatkins@dssolutions.com>:

Im sure this has been addressed somewhere, but I wasn’t able to locate any answers.

I have a postgres database running on a different host and I need to access it remotely from another box.

 

Boxes are CentOS 6, and I opened the firewall port 5432 on the database server host.

Also, on the database server host, I made the following entries to /var/lib/pgsql/9.6/data/pg_hba.conf.

local   all             all                                     md5

host    all             all             127.0.0.1/32            md5

host    all             all             10.42.42.16/24          md5

 

When I try to use psql to attach to the remote database, I get the following error:

[root@host1 ~]# psql -h host2 -p 5432 -U postgres

psql: FATAL:  no pg_hba.conf entry for host "10.0.0.254", user "postgres", database "postgres", SSL off