Re: psql shell with no password prompt

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Steve(dot)Toutant(at)inspq(dot)qc(dot)ca
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-admin(at)postgresql(dot)org
Subject: Re: psql shell with no password prompt
Date: 2010-07-27 19:34:41
Message-ID: AANLkTi=vs50mCreKWN-i9Sd5m0bqtkgtryj0XBs3Wjrg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Jul 27, 2010 at 12:16 PM, <Steve(dot)Toutant(at)inspq(dot)qc(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Craig James 2010-07-27 20:34:14 Re: postgresql basic info
Previous Message Kevin Grittner 2010-07-27 18:34:17 Re: psql shell with no password prompt