Re: Preventing access temporarily.

On Thu, Jan 26, 2012 at 3:58 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Thu, Jan 26, 2012 at 3:55 PM, Gauthier, Dave <dave(dot)gauthier(at)intel(dot)com> 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 suggestion.  I'll add that to my notes.
>
> Yeah either of those will work.  pg_hba.conf is nice for more complex
> setups and you can have several pg_hba.conf.whatever files laying
> about, link the right one and reload.  So it's pretty easy to script
> and back out for complex stuff.

Oh and also you can revoke connect by user which allows for finer
grained control of connections as well.