RE: md5 and trust and pg_hba.conf

Both have PGHOST set. gd07 has a .pgpass, but psgdba does not. Does it still need a .pgpass even if it is already ‘trust’?
Thanks.

Maria A Rossi
Database Administration
Jackson National Life
email: maria(dot)rossi(at)jackson(dot)com<mailto:maria(dot)rossi(at)jackson(dot)com>
cell phone: 517.256.4392
work phone: 517.367.3099
work phone extension: 23099

From: Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>
Sent: Monday, September 10, 2018 10:55 AM
To: Rossi, Maria <maria(dot)rossi(at)jackson(dot)com>
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org; pgsql-novice(at)lists(dot)postgresql(dot)org
Subject: Re: md5 and trust and pg_hba.conf

EXTERNAL EMAIL

On Mon, Sep 10, 2018 at 10:46 PM Rossi, Maria <maria(dot)rossi(at)jackson(dot)com<mailto:maria(dot)rossi(at)jackson(dot)com>> wrote:
Hi,

Question on pg_hba.conf. I have these entries:

host all psgdba localhost trust
host all psgdba 127.0.0.1/32<http://127.0.0.1/32> trust
host all gd07 localhost trust
host all gd07 127.0.0.1/32<http://127.0.0.1/32> trust

Can you post the whole of pg_hba.conf file?

You might have some other entry that is taking precedence.

Command to logon to Postgres:
/usr/pgsql-9.3/bin/psql -d postgres

If you don't have PGHOST set then most likely you are not going over a tcp connection (which is what host entries in pg_hba are used for). Instead the local entries of pg_hba are taking effect.

If I am logged on ‘gd07’ at the server , it lets me log-on to Postgres without prompting for password

do you have a *.pgpass* file in the home directory?

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

--

--

Best Regards,

Sameer Kumar | Senior Solution Architect

ASHNIK PTE. LTD.

36 Robinson Road, #14-04 City House, Singapore 068877

T: +65 6438 3504 | www.ashnik.com<http://www.ashnik.com/>

Skype: sameer.ashnik | M: +65 8110 0350

[Image removed by sender.]