Re: Preventing access temporarily.

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Preventing access temporarily.
Date: 2012-01-26 22:39:28
Message-ID: CAOR=d=0dxXdBye-_WBkuomH8379MMWHLz9MQr1QsJoq3ELCOQQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jan 26, 2012 at 3:05 PM, Gauthier, Dave <dave(dot)gauthier(at)intel(dot)com> 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gauthier, Dave 2012-01-26 22:55:29 Re: Preventing access temporarily.
Previous Message Gauthier, Dave 2012-01-26 22:05:43 Preventing access temporarily.