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.gauth...@intel.com> escribió:
> Hmmmm... 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 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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
