From: | Alexey Klyukin <alexk(at)hintbits(dot)com> |
---|---|
To: | Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com> |
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:41:54 |
Message-ID: | CAAS3tyJFD2xD60eHi56G8fkydMt-Mw6=fcFMn45xAjrh-+A3Uw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Thu, Apr 2, 2015 at 4:24 PM, Matheus de Oliveira
<matioli(dot)matheus(at)gmail(dot)com> wrote:
>
> On Thu, Apr 2, 2015 at 7:13 AM, Alexey Klyukin <alexk(at)hintbits(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Alexey Klyukin | 2015-04-02 15:01:11 | Re: base backup from the standby without pg_basebackup |
Previous Message | Denish Patel | 2015-04-02 14:32:46 | Re: base backup from the standby without pg_basebackup |