On Thu, Apr 2, 2015 at 4:24 PM, Matheus de Oliveira <matioli.matheus@xxxxxxxxx> wrote: > > On Thu, Apr 2, 2015 at 7:13 AM, Alexey Klyukin <alexk@xxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
