On 12/14/2017 01:19 AM, Laurenz Albe wrote:
> PropAAS DBA wrote:
>> we have a client using veeam to do vmware snapshots of the db servers,
>> unfortunately as far as I can tell any restore of a veeam snapshot also
>> restores the state, which means the db gets restored in an online state.
>> As far as I know, once the db is online we cannot force it back into
>> recovery mode to do a PITR recovery, correct?
>>
>> Anyone know of a way to do PITR recoveries with veeam?
> It is fairly simple.
>
> Before the snapshot, run
>
> SELECT pg_start_backup('label of your choice', TRUE);
>
> After the snapshot, run
>
> SELECT pg_stop_backup();
>
> Yours,
> Laurenz Albe
However restoring the snapshot with veeam will restore the db to a
running/online state, which means we cannot force it to go back into
recovery mode yes?