I found something else on the web. update pg_database set datallowconn = false where datname = 'foo'; update pg_database set datallowconn = true where datname = 'foo'; Seems to have worked OK. Thanks for the pg_hab.conf suggestion. I'll add that to my notes. -----Original Message----- From: Scott Marlowe [mailto:scott.marlowe@xxxxxxxxx] Sent: Thursday, January 26, 2012 5:39 PM To: Gauthier, Dave Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Preventing access temporarily. On Thu, Jan 26, 2012 at 3:05 PM, Gauthier, Dave <dave.gauthier@xxxxxxxxx> wrote: > PG V9.0.1 on Linux > > > > I want to temporarily prevent users from connecting to a DB, let the > existing connections finish, <do some work>, re-enable connections. > > What's the best way to do that? Edit pg_hba.conf to reject all connections and reload. current connections will stay connected, new ones will be refused. use pg_stat_activity to monitor connections til they're all gone / idle. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
