Bypassing authentication

Поиск
Список
Период
Сортировка
От Andre Majorel
Тема Bypassing authentication
Дата
Msg-id 20100708201926.GB2132@aym.net2.nerim.net
обсуждение исходный текст
Ответы Re: Bypassing authentication  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Bypassing authentication  (Frank Bax <fbax@sympatico.ca>)
Список pgsql-novice
Is there a way to have psql bypass authentication as joe if the
system user running psql is postgres, the way su doesn't ask for
password if you are root ?

sudo -u postgres psql -l         # psql doesn't ask for a password
sudo -u postgres psql -u joe -l  # psql asks for joe's password

joe is just a PostgreSQL role with no system counterpart so the
"local all all ident sameuser" catch-all in pg_hba.conf is of no
help here.

Thanks in advance.

--
André Majorel http://www.teaser.fr/~amajorel/

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

Предыдущее
От: Arvind Sharma
Дата:
Сообщение: Re: Triggers, Stored Procedures to Aggregate table ?
Следующее
От: "John T. Dow"
Дата:
Сообщение: Re: Dropped table, no backup, restore from file system backup or WAL files?