We have a server that backups and then recreates our production
database on a nightly basis In order to drop and recreate the database we would stop and restart
the server - this would Effectively kick off any straggling users so we could get our refresh
done. No problem. Now we have more than one database and stopping and restarting the
server to clean up The backup database would also kill any process going on in the new
database. Is there a command in postgres to disconnect all users short of
restarting The server? I looked at pg_ctl kill TERM but there I would need to Specify specific PIDs. Not something I want to do manually at 1 am
every morning. We are at postgres 8.2.5. Thanks for your help Committed to Creating @utoEnthusiasts. Please provide us with your feedback. Mark Steben│Database Administrator│ @utoRevenue™ A Division of Dominion
Enterprises |