Re: BDR and Backup and Recovery - Mailing list pgsql-general

From Will McCormick
Subject Re: BDR and Backup and Recovery
Date
Msg-id CA+jgkY4Wx1eZmnak24FMVY+kt73H5c51Ks8omrGuXu4LR52t6A@mail.gmail.com
Whole thread Raw
In response to Re: BDR and Backup and Recovery  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: BDR and Backup and Recovery
Re: BDR and Backup and Recovery
List pgsql-general
Re-sending to group as well Jim :D

Regarding testing backups, Well said Jim. Thanks for taking the time to respond. I will test regularly whatever we decide to put in place. 

The below is from the 0.9.3 BDR documentation:

"Because logical replication is only supported in streaming mode (rather than WAL archiving) it isn't suitable for point-in-time recovery. Logical replication may be used in conjunction with streaming physical replication and/or PITR, though; it is not necessary to choose one or the other." 

Am I misinterpreting that BDR uses Logical Decoding and as such I cannot perform PITR?

On Wed, Nov 18, 2015 at 11:19 AM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
On 11/18/15 9:46 AM, Will McCormick wrote:
What viable options exist for Backup & Recovery in a BDR environment?
 From the reading I have done PITR recovery is not an option with BDR.
It's important to preface this that I have almost no exposure to
postgres backup and recovery. Is PITR not an option with BDR?

If a user fat fingers something and deletes records from a table without
a where clause what is the correct course of action is to recover as
much data as possible. What type of backup do I require to restore as
much data as possible before the incident in a BDR environment.

Sorry for such an open ended question. :D I'm continuing to read as I
solicit feedback.

Is there a document outlining recovery with BDR?

I don't know why PITR wouldn't work with BDR, other than you can't use binary backups across incompatible versions and BDR might be considered incompatible with community Postgres. I would think it should still work fine if you try to restore to a BDR server.

That said, remember that if you are not regularly (preferably automatically) testing your backups by doing a restore and testing the restore, then you don't have a backup. You have a hope and a prayer. :)
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com

pgsql-general by date:

Previous
From: Emi
Date:
Subject: drop index without accessexclusivelock in transaction (JAVA)
Next
From: Adrian Klaver
Date:
Subject: Re: BDR and Backup and Recovery