fast or immediate stop?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux