Search Postgresql Archives

Re: v8.3.4 metadata changes while users active

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I'll be running this as "postgres"
Thanks for the help.
Hope others may find this useful.

-----Original Message-----
From: Bosco Rama [mailto:postgres@xxxxxxxxxxxxx] 
Sent: Thursday, April 05, 2012 12:04 PM
To: Gauthier, Dave
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re:  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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux