Re: Backup "Best Practices" - Mailing list pgsql-general

From Israel Brewster
Subject Re: Backup "Best Practices"
Date
Msg-id 52AFB2F3-AA09-4812-B517-E215533B9936@ravnalaska.net
Whole thread Raw
In response to Re: Backup "Best Practices"  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
On Nov 28, 2016, at 2:13 PM, John R Pierce <pierce@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

pgsql-general by date:

Previous
From: Andres Freund
Date:
Subject: Re: hot_standby_feedback
Next
From: "Mike Sofen"
Date:
Subject: Re: Storing files: 2.3TBytes, 17M file count