From: | PropAAS DBA <dba(at)propaas(dot)com> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: virtualized snapshots and PITR |
Date: | 2017-12-14 15:29:04 |
Message-ID: | cea78e48-194d-9443-ea1a-2dab60fe65e3@propaas.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2017-12-14 15:50:54 | Re: virtualized snapshots and PITR |
Previous Message | Laurenz Albe | 2017-12-14 09:30:10 | Re: virtualized snapshots and PITR |