Re: createdb.exe and psql.exe without Promting Password

From: Dennis Brakhane <brakhane(at)googlemail(dot)com>
To: Inigo Barandiaran <ibarandiaran(at)vicomtech(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: createdb.exe and psql.exe without Promting Password
Date: 2009-02-11 20:01:47
Message-ID: 226a19190902111201k654fc91fk12f929168c3df63c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Feb 10, 2009 at 7:04 PM, Inigo Barandiaran
<ibarandiaran(at)vicomtech(dot)org> wrote:
> I've read that if I define an environment variable like SET
> PGPPASSWORD=MyPosgresUserPassword, both calls dont ask for password. I've
> tested this variable in different platforms and does not work.
> Do you know how so solve it?

As you are dealing with PostgreSQL, and not Pretty Good Privacy, I'd
suggest removing the additional "P": PGPASSWORD, not PGPPASSWORD

But .pgpass is the Right Way to do it, IMHO

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2009-02-11 20:05:30 Re: Killing OIDs
Previous Message Steve Crawford 2009-02-11 19:59:22 Re: Killing OIDs