Re: psql remote database access

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


İyi çalışmalar.
Samed YILDIRIM



10.11.2016, 15:53, "Samed YILDIRIM" <samed@xxxxxxxxxx>:
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@xxxxxxxxxxxxxxx>:

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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux