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:[EMAIL PROTECTED] 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 » [EMAIL PROTECTED] » +64(21) 28 41 463 Deeper Design Limited » +64(7) 377 3328 » www.deeperdesign.com ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
