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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/