From: Ron Watkins <rwatkins@dssolutions.com>
To: 'Samed YILDIRIM' <samed@reddoc.net>
To: pgsql-admin@postgresql.org
Subject: Re: psql remote database access
Date: Thu, 10 Nov 2016 07:37:25 -0700
Message-ID: <248601d23b5f$f8053b30$e80fb190$@dssolutions.com> (raw)
In-Reply-To: <239761478786264@web23o.yandex.ru>
References: <abd561fd9692b8177d0bbdcc2028baf0@mail.gmail.com>
<215681478785987@web21o.yandex.ru>
<239761478786264@web23o.yandex.ru>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: rwatkins@dssolutions.com, samed@reddoc.net
Subject: Re: psql remote database access
In-Reply-To: <248601d23b5f$f8053b30$e80fb190$@dssolutions.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox