Re: psql shell with no password prompt

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(dot)Grittner(at)wicourts(dot)gov>
27/07/2010 01:17 PM

A
<Steve(dot)Toutant(at)inspq(dot)qc(dot)ca>, <pgsql-admin(at)postgresql(dot)org>
cc

Objet
Re: [ADMIN] psql shell with no password prompt

<Steve(dot)Toutant(at)inspq(dot)qc(dot)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