Postgres Pro
Downloads
Home   >   mailing lists

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

From Joshua D. Drake
Subject Re: psql shell with no password prompt
Date
Msg-id 1280255044.27165.1461.camel@jd-desktop.iso-8859-1.charter.com
Whole thread Raw
In response to Re: psql shell with no password prompt  (Steve.Toutant@inspq.qc.ca)
List pgsql-admin
Tree view 
On Tue, 2010-07-27 at 14:16 -0400, Steve.Toutant@inspq.qc.ca wrote:
>
> 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

Best practice? Use .pgpass, not trust.

JD

--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Postgresql for Windows 7
Next
From: Anj Adu
Date:
Subject: Raid Recommendation