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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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

  • From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • To: "gregory vallet" <gvallet(at)fr(dot)abx(dot)fr>
  • Cc: pgsql-bugs(at)postgresql(dot)org
  • Subject: Re: BUG #3711: dropdb and creatdb with pgpass.conf file
  • Date: Wed, 31 Oct 2007 17:47:11 -0400
  • Message-id: <21442.1193867231@sss.pgh.pa.us> <text/plain>
"gregory vallet" <gvallet(at)fr(dot)abx(dot)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
Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group