On 19 February 2018 at 16:17, David Steele <da...@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