Subject: Re: virtualized snapshots and PITR
To: Laurenz Albe <laurenz.albe@cybertec.at>,
 pgsql-admin <pgsql-admin@postgresql.org>
References: <38c84302-270e-a2b6-648f-26ba798d8787@propaas.com>
 <1513239540.2442.22.camel@cybertec.at>
From: PropAAS DBA <dba@propaas.com>
Message-ID: <cea78e48-194d-9443-ea1a-2dab60fe65e3@propaas.com>
Date: Thu, 14 Dec 2017 08:29:04 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.5.0
MIME-Version: 1.0
In-Reply-To: <1513239540.2442.22.camel@cybertec.at>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Precedence: bulk


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?