Re: pgBackRest backup from standby

On 19 February 2018 at 16:17, David Steele <david@pgmasters.net> wrote:
>>     > I did come up with a sort of Rube Goldberg-esque workaround for now
>>     > involving using a clone of the prod standby VM from Veeam backup to use
>>     > as the backup source (after stopping recovery and opening it as a
>>     > standalone DB).
>>
>>     You don't get PITR that way, of course, but at least it's a backup.  As
>>     long as your clone is consistent.
>>
>>
>> Yes it's a crash-consistent snapshot-based backup. I've done quite a few
>> restores from it and it works great. It can do PITR as well since I
>> would have all the WAL files from prod needed to keep recovering. But
>> for these cases I just recover it to the first consistent point and open
>> it for testing (or backups in this case).
>
> I don't think it would be safe to do PITR on a backup taken in this way.

If you have all the WAL files, then it would be safe.

>  The WAL diverges even if you suppress a timeline switch.

Which is exactly why we have timelines.

-- 
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services