Re: postgres hot-standby questions. - Mailing list pgsql-admin

From Scott Ribe
Subject Re: postgres hot-standby questions.
Date
Msg-id 06AC2E5A-2205-4CF5-82E6-9C35FBDDBF7F@elevated-dev.com
Whole thread Raw
In response to Re: postgres hot-standby questions.  ("Graeme B. Bell" <grb@skogoglandskap.no>)
Responses Re: postgres hot-standby questions.
List pgsql-admin
On Mar 26, 2015, at 10:08 AM, Graeme B. Bell <grb@skogoglandskap.no> 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
asynchronouslywithout 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@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice







pgsql-admin by date:

Previous
From: "Graeme B. Bell"
Date:
Subject: Re: postgres hot-standby questions.
Next
From: Scott Ribe
Date:
Subject: Re: postgres hot-standby questions.