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

Re: Forcing connections closed

From: "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com>
To: "Hadley Willan" <hadley(dot)willan(at)deeperdesign(dot)co(dot)nz>,"PGSQL Admin" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Forcing connections closed
Date: 2004-01-29 21:21:36
Message-ID: 71E37EF6B7DCC1499CEA0316A25683280105762A@loki.wc.globexplorer.net (view raw or flat)
Thread:
Lists: pgsql-admin
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




Responses

pgsql-admin by date

Next:From: Hadley WillanDate: 2004-01-29 21:25:54
Subject: Re: Forcing connections closed
Previous:From: Hadley WillanDate: 2004-01-29 21:03:51
Subject: Forcing connections closed

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