On Thu, Jan 26, 2012 at 3:58 PM, Scott Marlowe <[email protected]> wrote: > On Thu, Jan 26, 2012 at 3:55 PM, Gauthier, Dave <[email protected]> > 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. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
