Postgres Pro
Downloads
Home   >   mailing lists

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

From Steve.Toutant@inspq.qc.ca
Subject Re: psql shell with no password prompt
Date
Msg-id OFBEA1F9BE.61A9A74B-ON8525776D.0063C944-8525776D.00645AF1@isn.rtss.qc.ca
Whole thread Raw
In response to Re: psql shell with no password prompt  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: psql shell with no password prompt  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: psql shell with no password prompt  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: psql shell with no password prompt  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
Tree view

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@wicourts.gov>

27/07/2010 01:17 PM

A
<Steve.Toutant@inspq.qc.ca>, <pgsql-admin@postgresql.org>
cc
Objet
Re: [ADMIN] psql shell with no password prompt







<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: Alvaro Herrera
Date:
Subject: Re: pl/PHP build on PostgreSQL v9 beta?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: psql shell with no password prompt