| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Backup "Best Practices" |
| Date: | 2016-11-28 23:13:18 |
| Message-ID: | 112df8cf-738c-7957-8452-1e3829a48f6a@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
--
john r pierce, recycling bits in santa cruz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2016-11-28 23:39:16 | Re: hot_standby_feedback |
| Previous Message | Israel Brewster | 2016-11-28 22:50:55 | Re: Backup "Best Practices" |