On Thu, Jan 26, 2012 at 3:55 PM, Gauthier, Dave <dave.gauthier@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
