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? -----Original Message----- From: Bosco Rama [mailto:postg...@boscorama.com] Sent: Thursday, April 05, 2012 11:27 AM To: Gauthier, Dave Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] v8.3.4 metadata changes while users active Hey, Gauthier, Dave wrote: > Hmmmm... I don't have root access :-( Do you have the ability to alter the users/roles? If so, you could set their connection limit to 0 and then kick them off. Do your work and then set their connection limit back to the value it was before. The default is -1 (unlimited). Here's how to set the connection limit: alter role moduser connection limit 0; This is only really viable if the set of users is small. You mentioned only 2 before. I'm not sure if it was exactly 2 users or 2 "types" of users. Just a thought. Bosco. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
