On Thu, Jan 26, 2012 at 3:58 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Thu, Jan 26, 2012 at 3:55 PM, Gauthier, Dave <dave.gauthier@intel.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.