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@xxxxxxxxxxxx>
27/07/2010 01:17 PM |
|
<Steve.Toutant@xxxxxxxxxxx> 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
