fast or immediate stop? - Mailing list pgsql-admin

From Ray Stell
Subject fast or immediate stop?
Date
Msg-id 20091113193633.GA3317@cns.vt.edu
Whole thread Raw
Responses Re: fast or immediate stop?  ("Tomeh, Husam" <HTomeh@facorelogic.com>)
List pgsql-admin
Do people use "gp_ctl stop -m i" in production?  I've had some difficulty
with the apps admin getting all the clients shut during maintenance
windows.  I'm wondering what I should add to may init.d script, fast
or immediate.  The 8.3 doc says:

'"Fast" mode does not wait for clients to disconnect. All active transactions are rolled
back and clients are forcibly disconnected, then the server is shut down.'

"Immediate" mode will abort all server processes without a clean
shutdown. This will lead to a recovery run on restart.

Fast seems right, but I wonder.  Advice?  I'm at 8.3.6.

pgsql-admin by date:

Previous
From: Joe Miller
Date:
Subject: Re: unix_socket_group problem
Next
From: "Tomeh, Husam"
Date:
Subject: Re: fast or immediate stop?