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" <[email protected]> 27/07/2010 01:17 PM A <[email protected]>, <[email protected]> cc Objet Re: [ADMIN] psql shell with no password prompt <[email protected]> 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
