Postgres Pro
Downloads
Home   >   mailing lists

lock a database from new connections, without modifying pg_hba.conf - Mailing list pgsql-admin

From Marc G. Fournier
Subject lock a database from new connections, without modifying pg_hba.conf
Date
Msg-id 20060518141816.Q1145@ganymede.hub.org
Whole thread Raw
Responses Re: lock a database from new connections, without modifying pg_hba.conf  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: lock a database from new connections, without modifying  ("Ben K." <bkim@coe.tamu.edu>)
List pgsql-admin
Tree view 
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) ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

pgsql-admin by date:

Previous
From: "Mathias Laurent"
Date:
Subject: [JDBC] InsertRow problem with Serial
Next
From: "ashok@kalculate.com"
Date:
Subject: find out all users under specific user