Thread: pg_hba.conf settings for postgres
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.
Teju Jakkidi vlogs <teja.jakkidi05@gmail.com> writes: > 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 So psql is connecting to the "local IP", not to the loopback address. This is probably a matter of DNS configuration, but since you didn't show us the exact command, it's hard to say more than that. regards, tom lane
Try to change it to tru an not trust reason being I it works semantics rather than true or false or should be try true not trust see i bot for that network remind the Tex is that.
From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Saturday, February 17, 2024 12:40:21 PM
To: Teju Jakkidi vlogs <teja.jakkidi05@gmail.com>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: pg_hba.conf settings for postgres
Sent: Saturday, February 17, 2024 12:40:21 PM
To: Teju Jakkidi vlogs <teja.jakkidi05@gmail.com>
Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: pg_hba.conf settings for postgres
Teju Jakkidi vlogs <teja.jakkidi05@gmail.com> writes:
> 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
So psql is connecting to the "local IP", not to the loopback address.
This is probably a matter of DNS configuration, but since you didn't
show us the exact command, it's hard to say more than that.
regards, tom lane
> 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
So psql is connecting to the "local IP", not to the loopback address.
This is probably a matter of DNS configuration, but since you didn't
show us the exact command, it's hard to say more than that.
regards, tom lane