Re: [BUGS] BUG #3711: dropdb and creatdb with pgpass.conf file

2007-10-31 Thread Heikki Linnakangas
gregory vallet wrote: 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:xxx" With the pg_dump command, it's OK with dropdb and creatdb, system asks me for the password. If I replace "02HH65"

Re: [BUGS] BUG #3711: dropdb and creatdb with pgpass.conf file

2007-10-31 Thread Tom Lane
"gregory vallet" <[EMAIL PROTECTED]> writes: > Why do dropdb and creatdb can't recognize my database name? dropdb and createdb always connect to the "postgres" database, which you did not put an entry for into your pgpass file. As a rule I'd suggest wildcarding the database column in pgpass; it's

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

2007-10-31 Thread gregory vallet
The following bug has been logged online: Bug reference: 3711 Logged by: gregory vallet Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows XP Description:dropdb and creatdb with pgpass.conf file Details: In order to automatized the pa