md5 and trust and pg_hba.conf
"Rossi, Maria" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.sql,gmane.comp.db.postgresql.novice |
|---|---|
| Message-ID | <daa1d04cccf6417e83a3f52cd8ab1781@DC03PXMBP003.jacksonnational.com> |
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