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