Re: base backup from the standby without pg_basebackup

From: Alexey Klyukin <alexk(at)hintbits(dot)com>
To: Vladimir Borodin <root(at)simply(dot)name>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: base backup from the standby without pg_basebackup
Date: 2015-04-02 14:19:23
Message-ID: CAAS3ty+QMxui7kKArSbYChtBAiyXQNDZpasPrCKOr9gk6S7y2Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Apr 2, 2015 at 3:27 PM, Vladimir Borodin <root(at)simply(dot)name> wrote:
>
> 2 апр. 2015 г., в 15:50, Alexey Klyukin <alexk(at)hintbits(dot)com> написал(а):
>
> Hi Vladimir,
>

> Well, I haven’t ever tried to do so, but I think the reason that replica
> starts applying WALs from too late location is that you do not copy backup
> label file from master after issuing pg_start_backup. Does your tool copy it
> from master?

Yes, it doesn't exclude it explicitly ,hence, it's archived together
with other files.

Of course, things are getting funny when the archive is taken from the
replica and the label is created on the master, but in fact the
recovery will try to auto detect the initial position even without a
label, so at the end it's likely that the lack of label file is not
the culprit.

--
Regards,
Alexey Klyukin

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Matheus de Oliveira 2015-04-02 14:24:56 Re: base backup from the standby without pg_basebackup
Previous Message Vladimir Borodin 2015-04-02 13:27:52 Re: base backup from the standby without pg_basebackup