Hello Admins,
local all postgres trust
local all all md5
host all all 127.0.0.1/32 trust
host all all 0.0.0.0/0 md5
host all all ::1/128 trust
I have below settings in my pg_hba.conf file:
local all postgres trust
local all all md5
host all all 127.0.0.1/32 trust
host all all 0.0.0.0/0 md5
host all all ::1/128 trust
host all all ::/0 md5
Our expectation is that - when logging as postgres user from local host, it should not prompt for the password as we have local for postgres set to trust and loopback is set to trust.
However, when running psql as postgres user from the local host, it is still asking for the password.
Adding below lines in
pg_hba.conf file is working as expected:
host all postgres Local IP/32 trust
Adding an entry for local host IP and making it trust for postgres user is working as expected and not prompting for password. However, removing this line is prompting for the postgres password from the local host.
Not sure why there needs to be an entry for IP even when we already have local for postgres and loopback set to trust.
Any inputs here will be of great help!!
Thanks,
Teja.