Hi,
you can use
pg_ctl stop -m fast
pg_ctl start
who kill client and abort current transaction
and if you have multiple database you can use the -D option for
specify database directory
-manu
Le 15 oct. 08 à 16:11, Mark Steben a écrit :
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™
95 Ashley Ave. West Springfield, MA., 01089
413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax)
A Division of Dominion Enterprises
