On Nov 28, 2016, at 2:13 PM, John R Pierce <pie...@hogranch.com> wrote: > > On 11/28/2016 2:50 PM, Israel Brewster wrote: >>> >>> Why wouldn't the streaming replica salvage that? Are they expected to fail >>> together? Is the NFS share onto which you want to store your basebackup >>> and WAL also expected to fail together with them? >> >> That's why I specified *total* failure. If only the primary dies, that's a >> simple cutover to the secondary, and not a total failure - no need to go to >> backups of any sort under that scenario :-) I'm thinking more along the >> lines of server room burns down, natural disaster, etc - something that >> causes a total failure of the db system, necessitating recovery from an >> offsite backup. > > your base backups and WAL archive should be replicated offsite, then. > >
Obviously :-) > > -- > john r pierce, recycling bits in santa cruz
