Re: [GENERAL] BDR and Backup and Recovery

2015-11-20 Thread Craig Ringer
On 19 November 2015 at 00:54, Will McCormick wrote: > 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 w

Re: [GENERAL] BDR and Backup and Recovery

2015-11-19 Thread Craig Ringer
On 18 November 2015 at 23:46, 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

Re: [GENERAL] BDR and Backup and Recovery

2015-11-18 Thread Adrian Klaver
On 11/18/2015 09:31 AM, Will McCormick wrote: Ccing list Thanks Adrian. I think I have it Lets say we have 2 nodes: Node A Node B GOOD Application Writes only occurring against Node A 1) Node A Base Backup taken 2) User Error occurs that replicates Can restore and Recover Node A to PITR b

Re: [GENERAL] BDR and Backup and Recovery

2015-11-18 Thread Jim Nasby
On 11/18/15 10:53 AM, Will McCormick wrote: 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

Re: [GENERAL] BDR and Backup and Recovery

2015-11-18 Thread Adrian Klaver
On 11/18/2015 08:54 AM, Will McCormick wrote: 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 replicatio

Re: [GENERAL] BDR and Backup and Recovery

2015-11-18 Thread Will McCormick
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 th

Re: [GENERAL] BDR and Backup and Recovery

2015-11-18 Thread Jim Nasby
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 opt