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

Re: Forcing connections closed

From: Hadley Willan <hadley(dot)willan(at)deeperdesign(dot)co(dot)nz>
To: "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com>
Cc: PGSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Forcing connections closed
Date: 2004-01-29 21:25:54
Message-ID: 1075411554.23417.13.camel@atlas.sol.deeper.co.nz (view raw or flat)
Thread:
Lists: pgsql-admin
Thanks for that, however that's quite heavy handed in that it will stop
the postgres instance.

Is there any way to close connections to a database without stopping
postgres itself? 

E.G I have three databases, A,B and C, and only want to close C.

Thanks

On Fri, 2004-01-30 at 10:21, Gregory S. Williamson wrote:

> pg_ctl stop    [-W] [-D DATADIR] [-s] [-m SHUTDOWN-MODE]
> 
> e.g. 
> 
> pg_ctl stop -D /data/postgres/gex_runtime -m fast
> 
> will shut down all connections and stop the postgres instance:
> Shutdown modes are:
>   smart       quit after all clients have disconnected
>   fast        quit directly, with proper shutdown
>   immediate   quit without complete shutdown; will lead to recovery on restart
> 
> HTH,
> 
> Greg Williamson
> DBA
> GlobeXplorer LLC
> 
> -----Original Message-----
> From:	Hadley Willan [mailto:hadley(dot)willan(at)deeperdesign(dot)co(dot)nz]
> Sent:	Thu 1/29/2004 1:03 PM
> To:	PGSQL Admin
> Cc:	
> Subject:	[ADMIN] Forcing connections closed
> 
> Hello,
>     How do I force postmaster to terminate active connections on other
> databases?
> 
> Thanks

-- 
Hadley Willan » Director » hadley(dot)willan(at)deeperdesign(dot)com » +64(21) 28
41 463
Deeper Design Limited » +64(7) 377 3328 » www.deeperdesign.com

In response to

Responses

pgsql-admin by date

Next:From: Ryan ChambersDate: 2004-01-29 21:48:22
Subject: Re: Forcing connections closed
Previous:From: Gregory S. WilliamsonDate: 2004-01-29 21:21:36
Subject: Re: Forcing connections closed

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