Postgres Pro
Downloads
Home   >   mailing lists

Re: psql shell with no password prompt - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: psql shell with no password prompt
Date
Msg-id 4C4ECE440200002500033D7C@gw.wicourts.gov
Whole thread Raw
In response to psql shell with no password prompt  (Steve.Toutant@inspq.qc.ca)
Responses Re: psql shell with no password prompt  (Steve.Toutant@inspq.qc.ca)
List pgsql-admin
Tree view 
<Steve.Toutant@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

pgsql-admin by date:

Previous
From: Steve.Toutant@inspq.qc.ca
Date:
Subject: psql shell with no password prompt
Next
From: Alvaro Herrera
Date:
Subject: Re: pl/PHP build on PostgreSQL v9 beta?