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

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: 2007-10-31 21:47:11
Message-ID: 21442.1193867231@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"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

In response to

pgsql-bugs by date

Next:From: Idris KhanafiDate: 2007-11-01 04:29:57
Subject: Tsearch in Postgresql 8.2.5
Previous:From: Heikki LinnakangasDate: 2007-10-31 21:38:42
Subject: Re: BUG #3711: dropdb and creatdb with pgpass.conf file

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