Re: backup server - how to disconnect

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
>
>
>
>