On 9/18/23 12:45, Johnson, Bruce E - (bjohnson) wrote:
I am doing some testing trying to migrate some websites from using
Oracle to Postgres. (Using Perl DBI and DBD::Pg as the connecting
mechanism)
(Server Environment Postgres 15 running on Ubuntu 22.04, client Rocky
Linux using the supplied PostgreSQL DBI and DBD::Pg packages)
The error I am getting on the client is:
password authentication failed for user "trav"
connection to server at "dhbpostgres.pharmacy.arizona.edu"
(10.128.206.109), port 5432 failed: FATAL: no pg_hba.conf entry for
host "10.128.206.109", user "trav", database "webdata", no encryption
But I do have an entry that should allow it:
#Internal server mgmt range
hostsslallall10.128.206.0/23 password
I guessing you want that to be:
10.128.206.109/32
or
10.128.206.0/24
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
