Skip site navigation (1) Skip section navigation (2)

Re: backup server - how to disconnect

From: Emmanuel BERTHOULE <eberthoule(at)yahoo(dot)fr>
To: Mark Steben <msteben(at)autorevenue(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: backup server - how to disconnect
Date: 2008-10-15 20:10:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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


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

In response to

pgsql-admin by date

Next:From: Fabrízio de Royes MelloDate: 2008-10-15 21:25:20
Subject: Re: backup server - how to disconnect
Previous:From: Mark StebenDate: 2008-10-15 14:11:58
Subject: backup server - how to disconnect

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group