It goes through pg_hba.conf <in order>. So do you have other lines above these lines that would match a local
connection,but have md5, or one of the other authentication methods set?
Since you mentioned gd07 has a pgpass file then I don't think it's a case of the pg_hba line being right for gd07 and
wrongfor psgdba, I think they're both "wrong" in that a previous line is being used which prompts for a password, and
sincegd07 has a password stored, then it uses that and winds up connected ok in the end.
From: Rossi, Maria [mailto:maria.rossi@jackson.com]
Sent: Monday, September 10, 2018 10:46 AM
To: 'pgsql-sql@lists.postgresql.org'; 'pgsql-novice@lists.postgresql.org'
Subject: md5 and trust and pg_hba.conf
Hi,
Question on pg_hba.conf. I have these entries:
host all psgdba localhost trust
host all psgdba 127.0.0.1/32 trust
host all gd07 localhost trust
host all gd07 127.0.0.1/32 trust
Command to logon to Postgres:
/usr/pgsql-9.3/bin/psql -d postgres
If I am logged on ‘gd07’ at the server , it lets me log-on to Postgres without prompting for password
If I am logged on as ‘psgdba’, it prompts for password.
As you can see, both have ‘trust’, but ‘gd07’ is the instance owner.
Why does ‘psgdba’ prompts? What I am missing?
Your help would be much appreciated.
Thanks.
Maria