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

From Scott Marlowe
Subject Re: psql shell with no password prompt
Date
Msg-id AANLkTi=vs50mCreKWN-i9Sd5m0bqtkgtryj0XBs3Wjrg@mail.gmail.com
Whole thread Raw
In response to Re: psql shell with no password prompt  (Steve.Toutant@inspq.qc.ca)
List pgsql-admin
On Tue, Jul 27, 2010 at 12:16 PM, <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

You have to reload / restart the pg service for that to take effect.
Note that will only affect incoming connections on the same machine.

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: psql shell with no password prompt
Next
From: Lazarin Toni
Date:
Subject: postgresql basic info