Postgres 7.4: how to disconnect users without restarting postmaster

From: Manoj Lal <mlal_1974(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres 7.4: how to disconnect users without restarting postmaster
Date: 2007-04-04 06:42:48
Message-ID: 555163.97053.qm@web50807.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I have the following requirements, and I want to do them without shutting down postgres. Any help appreciated.

1. Get a list of connections to the postgres server
2. Disconnect some/all connections from postgres

3. I modified the pg_hba.conf to block a particular user from connecting to the DB. Then I issued the 'pg_ctl reload' command to send a SIGHUP to the server. After this I see the following:
a. Any new connection request from the user is blocked
b Any existing connection from that user (that was already opened, and is being pooled) doesn't get rejected.
Is (b) the expected behavior? How do I force existing connections from the user to be dropped without restarting db?

thanks
mlal


____________________________________________________________________________________
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
http://answers.yahoo.com/dir/?link=list&sid=396546091

Browse pgsql-general by date

  From Date Subject
Next Message marcel.beutner 2007-04-04 07:14:39 newid() in postgres
Previous Message Martijn van Oosterhout 2007-04-04 06:20:43 Re: UPDATE on two large datasets is very slow