On Thu, Jan 26, 2012 at 3:58 PM, Scott Marlowe wrote:
> On Thu, Jan 26, 2012 at 3:55 PM, Gauthier, Dave
> wrote:
>> 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';
>>
On Thu, Jan 26, 2012 at 3:55 PM, Gauthier, Dave wrote:
> 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 suggest
.
-Original Message-
From: Scott Marlowe [mailto:scott.marl...@gmail.com]
Sent: Thursday, January 26, 2012 5:39 PM
To: Gauthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Preventing access temporarily.
On Thu, Jan 26, 2012 at 3:05 PM, Gauthier, Dave wrote:
> PG V9.0.
On Thu, Jan 26, 2012 at 3:05 PM, Gauthier, Dave wrote:
> PG V9.0.1 on Linux
>
>
>
> I want to temporarily prevent users from connecting to a DB, let the
> existing connections finish, , re-enable connections.
>
> What's the best way to do that?
Edit pg_hba.conf to reject all connections and reloa
PG V9.0.1 on Linux
I want to temporarily prevent users from connecting to a DB, let the existing
connections finish, , re-enable connections.
What's the best way to do that?
Thanks in Advance
