fast or immediate stop?

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: fast or immediate stop?
Date: 2009-11-13 19:36:33
Message-ID: 20091113193633.GA3317@cns.vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tomeh, Husam 2009-11-13 19:49:38 Re: fast or immediate stop?
Previous Message Joe Miller 2009-11-13 17:58:34 Re: unix_socket_group problem