I'll be running this as "postgres" Thanks for the help. Hope others may find this useful.
-----Original Message----- From: Bosco Rama [mailto:postg...@boscorama.com] Sent: Thursday, April 05, 2012 12:04 PM To: Gauthier, Dave Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] v8.3.4 metadata changes while users active Gauthier, Dave wrote: > Hmmm.... This sounds like it might work. > There are, in fact, only 2 users (roles). Lets call them "selectuser" and > "moduser" > So, as the DBA, I just... > > alter role selectuser connection limit 0; > alter role moduser connection limit 0; > > Then kick everyone off (I usually use "pg_ctl kill TERM <procpid>" to do this) > > Make changes as the DBA > Then... > > alter role selectuser connection limit -1; > alter role moduser connection limit -1; > > Done ! > > Correct? Yep. That should work. The only reservation I'd bring up here is that you should be doing this as a user other than one of those two users. Otherwise you may lock yourself out of the DB. I assume you'll be doing this as either a PG superuser (e.g. postgres) or a user distinct from the two above. HTH Bosco. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
