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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
