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]
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
uthier, Dave
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] v8.3.4 metadata changes while users active
Hey,
Gauthier, Dave wrote:
> H... 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 ki
Hey,
Gauthier, Dave wrote:
> H... 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 (unli
On Thu, 2012-04-05 at 03:17 +, Gauthier, Dave wrote:
> H... I don't have root access :-(
>
In that case, ask your sysadmin to grant you sudo access to iptables or,
if he thinks that is excessive, to write a wrapper script that
enables/disables just that port and give you sudo access to th
[mailto:
> pgsql-general-ow...@postgresql.org] On Behalf Of Gabriel Ramirez
> Sent: Wednesday, April 04, 2012 11:00 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] v8.3.4 metadata changes while users active
>
> On 04/04/2012 09:26 PM, Gauthier, Dave wrote:
&
On 04/04/12 7:26 PM, Gauthier, Dave wrote:
v8.3.4 on linux
8.3 is currently at 8.3.18, there's been a LOT of fixes.
--
john r pierceN 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.
H... I don't have root access :-(
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Gabriel Ramirez
Sent: Wednesday, April 04, 2012 11:00 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] v8.3.4 met
On 04/04/2012 09:26 PM, Gauthier, Dave wrote:
v8.3.4 on linux
Here's the problem...
I need toboot them off and prevent them from getting back in so that I
can make the changes, then re-enable them. There are 2 users, lets call
them "selectuser" and "moduser" who have "select" and
"select,insert
