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.gritt...@wicourts.gov> 
27/07/2010 01:17 PM

A
<steve.tout...@inspq.qc.ca>, <pgsql-admin@postgresql.org>
cc

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








<steve.tout...@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



Reply via email to