Re: base backup from the standby without pg_basebackup

On Thu, Apr 2, 2015 at 4:24 PM, Matheus de Oliveira
<matioli.matheus@gmail.com> wrote:
>
> On Thu, Apr 2, 2015 at 7:13 AM, Alexey Klyukin <alexk@hintbits.com> wrote:
>>
>> So, the
>> question is, how would one make a base backup from the [async] standby
>> without using pg_basebackup.
>
>
> Check the following link, it provides the steps required to do exactly this:
>
> https://wiki.postgresql.org/wiki/Incrementally_Updated_Backups

Thanks, a useful link, and it actually proves my concerns:

3. Run pg_controldata on the standby and wait for "Latest checkpoint's
REDO location" to equal or exceed the WAL information reported by
pg_start_backup(). You might need to call pg_switch_xlog() on the
master to force the required WAL file to be sent to the standby.

So this step is designed to wait until the replica is up-to-date with
the master's state at the time of pg_start_backup.


--
Regards,
Alexey Klyukin