Re: Forcing connections closed

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