Re: .pgpass being ignored

From: Stephen Rasku <postgres(at)srasku(dot)net>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: .pgpass being ignored
Date: 2013-06-21 23:29:22
Message-ID: CA+BUyJk97O0xAAPg4D1Xo4CFG+hmAtUx3qA=5pvDb3Br_DC4Yw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jun 21, 2013 at 3:41 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:
>
> First are you running the script from the location with .pgpass?

I wasn't but I copied the .pgpass into the local directory and I get
the same results. The correct location is actually in the home
directory.

> Second you are doing a createdb, not sure how Postgres handles using .pgpass
> with database that does not exist yet? Might want to try a '*' in the database name
> field or since it looks like it is trying to connect to the postgres database, use that
> as the database name.

The database actually exists, so createdb should fail with a "database
exists" error. However, it didn't get there.

I took your advice anyways and it fixes the problem. Thanks!

...Stephen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-06-21 23:35:15 Re: .pgpass being ignored
Previous Message Stephen Rasku 2013-06-21 23:03:21 Re: .pgpass being ignored