Re: Forcing connections closed - Mailing list pgsql-admin

From Gregory S. Williamson
Subject Re: Forcing connections closed
Date
Msg-id 71E37EF6B7DCC1499CEA0316A25683280105762A@loki.wc.globexplorer.net
Whole thread Raw
In response to Forcing connections closed  (Hadley Willan <hadley.willan@deeperdesign.co.nz>)
Responses Re: Forcing connections closed
List 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.willan@deeperdesign.co.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.willan@deeperdesign.com » +64(21) 28
41 463
Deeper Design Limited » +64(7) 377 3328 » www.deeperdesign.com




pgsql-admin by date:

Previous
From: Hadley Willan
Date:
Subject: Forcing connections closed
Next
From: Hadley Willan
Date:
Subject: Re: Forcing connections closed