| From: | "Rossi, Maria" <maria(dot)rossi(at)jackson(dot)com> |
|---|---|
| To: | "'pgsql-sql(at)lists(dot)postgresql(dot)org'" <pgsql-sql(at)lists(dot)postgresql(dot)org>, "'pgsql-novice(at)lists(dot)postgresql(dot)org'" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
| Subject: | md5 and trust and pg_hba.conf |
| Date: | 2018-09-10 14:45:38 |
| Message-ID: | daa1d04cccf6417e83a3f52cd8ab1781@DC03PXMBP003.jacksonnational.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sameer Kumar | 2018-09-10 14:55:26 | Re: md5 and trust and pg_hba.conf |
| Previous Message | io.sys | 2018-08-31 04:06:32 | Re: syntax error in plperl wrapper for Perl regex replace. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sameer Kumar | 2018-09-10 14:55:26 | Re: md5 and trust and pg_hba.conf |
| Previous Message | Pavel Stehule | 2018-09-05 09:41:15 | Re: XMLTABLE question |