From: | Bosco Rama <postgres(at)boscorama(dot)com> |
---|---|
To: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: v8.3.4 metadata changes while users active |
Date: | 2012-04-05 16:04:25 |
Message-ID: | 4F7DC289.2060605@boscorama.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Gauthier, Dave | 2012-04-05 16:16:21 | Re: v8.3.4 metadata changes while users active |
Previous Message | Gauthier, Dave | 2012-04-05 15:38:25 | Re: v8.3.4 metadata changes while users active |