Skip site navigation (1) Skip section navigation (2)

BUG #3711: dropdb and creatdb with pgpass.conf file

From: "gregory vallet" <gvallet(at)fr(dot)abx(dot)fr>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3711: dropdb and creatdb with pgpass.conf file
Date: 2007-10-31 16:46:30
Message-ID: 200710311646.l9VGkU3l020772@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3711
Logged by:          gregory vallet
Email address:      gvallet(at)fr(dot)abx(dot)fr
PostgreSQL version: 8.2
Operating system:   Windows XP
Description:        dropdb and creatdb with pgpass.conf file
Details: 

In order to automatized the password on commands like pg_dump, dropdb and
creatdb, I created a pgpass.conf file with
"localhost:5432:02HH65:superuser:xxxxxxx"

With the pg_dump command, it's OK
with dropdb and creatdb, system asks me for the password.

If I replace "02HH65" with "*" like "localhost:5432:*:superuser:xxxxxxx",
it's OK for dropdb and creatdb.

Why do dropdb and creatdb can't recognize my database name?

Responses

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2007-10-31 21:38:42
Subject: Re: BUG #3711: dropdb and creatdb with pgpass.conf file
Previous:From: Adam TomjackDate: 2007-10-31 16:03:23
Subject: Re: I incrementally altered my database into a state where backups couldn't be restored.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group