Re: passing passords to pgsql/pg_create/pg_dump programmatically

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: Lars Haugseth <njus(at)larshaugseth(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: passing passords to pgsql/pg_create/pg_dump programmatically
Date: 2007-03-20 14:19:23
Message-ID: 45FFED6B.9090407@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 20/03/2007 14:04, Lars Haugseth wrote:

> As you can see, all of these command line utilities accept the -W
> parameter followed by the password.

Correct me if I'm wrong, but doesn't -W simply force a prompt from the
password? - it doesn't accept the password on the command line.

Using the .pgpass file allows command line utilities to run unattended
without having to supply a password manually.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2007-03-20 14:21:41 Re: Reference Type in PostgreSQL
Previous Message Lars Haugseth 2007-03-20 14:04:44 Re: passing passords to pgsql/pg_create/pg_dump programmatically