SEO

#1 (**permalink**) 04-10-2008, 11:11 AM

The following bug has been logged online:

Bug reference: 3711
Logged by: gregory vallet
Email address: gvallet@fr.abx.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?

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

#2 (**permalink**) 04-10-2008, 11:11 AM

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: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?

createdb and dropdb are different from pg_dump and other commands in
that it always connects to the "postgres" database (or "template1", if
you're deleting or creating the postgres database), not your application
database, to execute the "CREATE DATABASE" or "DROP DATABASE" command.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

#3 (**permalink**) 04-10-2008, 11:11 AM

"gregory vallet" <gvallet@fr.abx.fr> 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 pretty much useless.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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