md5 and trust and pg_hba.conf

Поиск
Список
Период
Сортировка
От Rossi, Maria
Тема md5 and trust and pg_hba.conf
Дата
Msg-id daa1d04cccf6417e83a3f52cd8ab1781@DC03PXMBP003.jacksonnational.com
обсуждение исходный текст
Ответы Re: md5 and trust and pg_hba.conf  (Sameer Kumar <sameer.kumar@ashnik.com>)
Re: md5 and trust and pg_hba.conf  (Sameer Kumar <sameer.kumar@ashnik.com>)
RE: md5 and trust and pg_hba.conf  (David Raymond <David.Raymond@tomtom.com>)
RE: md5 and trust and pg_hba.conf  (David Raymond <David.Raymond@tomtom.com>)
Список 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

 

В списке pgsql-sql по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: XMLTABLE question
Следующее
От: Sameer Kumar
Дата:
Сообщение: Re: md5 and trust and pg_hba.conf