Re: v8.3.4 metadata changes while users active

Try to reject the connections by using pg_hba.conf, only accepting
connections of localhost or your IP.
El 04/04/2012 22:18, "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> escribió:

> Hmmmm... I don't have root access :-(
>
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:
> pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Gabriel Ramirez
> Sent: Wednesday, April 04, 2012 11:00 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] v8.3.4 metadata changes while users active
>
> 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,update,delete" respectively and a dozenor so tables, plus
> > many stored procedures and functions. So I'm not sure revoke/grant is
> > such a great idea because I think I'd have to grant the privs back to
> > all those elements.
> >
> > Thanks fora ny ideas?
> >
> Well something along this can work
>
> try this as root
>
> iptables -I INPUT -m state --state NEW -m tcp -p tcp --dport 5432 -j DROP
> boot ogff your users
> make changes
> iptables -D INPUT -m state --state NEW -m tcp -p tcp --dport 5432 -j DROP
>
> regards,
>
> Gabriel
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>