On Mar 26, 2015, at 10:08 AM, Graeme B. Bell <grb@xxxxxxxxxxxxxxxxx> wrote: > > Assuming that you have your server configured with 1 or more hot standbys. > Are there situations where it is smart & sane to allow a controlled (slow, not emergency) shutdown to complete asynchronously without knowing if any standby got the last bits of wal? Sure. Point updates. Shut down 9.4.0. Immediately re-start 9.4.1 on the same cluster. OS security update, reboot server, PG shuts down and re-starts on boot. Etc. I don't care in those cases what the state of the network and my remote replicas are. The replication is interrupted briefly, and then resumes. -- Scott Ribe scott_ribe@xxxxxxxxxxxxxxxx http://www.elevated-dev.com/ https://www.linkedin.com/in/scottribe/ (303) 722-0567 voice -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
