Re: psql shell with no password prompt
| От | Steve.Toutant@inspq.qc.ca |
|---|---|
| Тема | Re: psql shell with no password prompt |
| Дата | |
| Msg-id | OFBEA1F9BE.61A9A74B-ON8525776D.0063C944-8525776D.00645AF1@isn.rtss.qc.ca обсуждение исходный текст |
| Ответ на | Re: psql shell with no password prompt ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>) |
| Ответы |
Re: psql shell with no password prompt
Re: psql shell with no password prompt Re: psql shell with no password prompt |
| Список | pgsql-admin |
Thanks Kevin,
Which of these 2 methods is the best practice?
It is working with pgpass.
But not yet with hba.conf
I tried this without success.
host all all 127.0.0.1/32 trust
steve
| "Kevin Grittner" <Kevin.Grittner@wicourts.gov> 27/07/2010 01:17 PM |
|
<Steve.Toutant@inspq.qc.ca> wrote:
> The script prompt for a password for user dbadmin.
> How to avoid that? I guess there is a config so dbadmin will
> "trust" this new user....
You can use pg_hba.conf or pgpass:
http://www.postgresql.org/docs/current/interactive/auth-pg-hba-conf.html
http://www.postgresql.org/docs/current/interactive/libpq-pgpass.html
-Kevin
В списке pgsql-admin по дате отправления: