BDR and Backup and Recovery

From: Will McCormick <wmccormick(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: BDR and Backup and Recovery
Date: 2015-11-18 15:46:04
Message-ID: CA+jgkY4Bp8eKdRfMcL=Fb9QHg20zFa4PmRPK+N=P80hGfeX3Vg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2015-11-18 16:19:51 Re: BDR and Backup and Recovery
Previous Message dinesh kumar 2015-11-18 11:18:49 Re: SQL conversion tool