Re: psql shell with no password prompt

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <Steve(dot)Toutant(at)inspq(dot)qc(dot)ca>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: psql shell with no password prompt
Date: 2010-07-27 17:17:08
Message-ID: 4C4ECE440200002500033D7C@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<Steve(dot)Toutant(at)inspq(dot)qc(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Steve.Toutant 2010-07-27 18:16:09 Re: psql shell with no password prompt
Previous Message Alvaro Herrera 2010-07-27 17:16:41 Re: pl/PHP build on PostgreSQL v9 beta?