> Is that possible? I've checked the docs for 8.1, and am not finding anything,
> nor anything in contrib ...
> the best I've been able to think of so far is to modify pg_hba.conf to not
> allow new connections for the duration of the operations I need to perform
> (drop and create a database) ...
Just in case ...
update pg_catalog.pg_database set datallowconn = false where datname =
In response to
pgsql-admin by date
|Next:||From: Ben K.||Date: 2006-05-20 16:02:59|
|Subject: Re: find out all users under specific user|
|Previous:||From: Magus||Date: 2006-05-19 20:33:32|
|Subject: Re: postgres[xxxx]: [4-1] FATAL: role "pgsql" does not exist|