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