psql remote database access

From: Ron Watkins <rwatkins(at)dssolutions(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: psql remote database access
Date: 2016-11-09 18:00:24
Message-ID: abd561fd9692b8177d0bbdcc2028baf0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Samed YILDIRIM 2016-11-10 13:53:07 Re: psql remote database access
Previous Message Igor Neyman 2016-11-08 18:56:30 Re: PG 9..5 index performance Q's