lock a database from new connections, without modifying pg_hba.conf

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: lock a database from new connections, without modifying pg_hba.conf
Date: 2006-05-18 17:22:50
Message-ID: 20060518141816.Q1145@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ashok@kalculate.com 2006-05-18 17:54:00 find out all users under specific user
Previous Message Mathias Laurent 2006-05-18 16:43:39 [JDBC] InsertRow problem with Serial