From: Stefan Fercot <stefan.fercot@dalibo.com>
To: Aldo Sarmiento <aldo@bigpurpledot.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: PG backrest restore
Date: Thu, 11 Jan 2018 10:41:35 +0100
Message-ID: <a9a1fbec-e0b1-0fe2-1367-9050a2c2ab77@dalibo.com> (raw)
In-Reply-To: <CAHX=r6z7_DrwKfNOUCohRnbTfk5xxQAfQ4_yMVCu5a3WDQr+mg@mail.gmail.com>
References: <CAHX=r6z7_DrwKfNOUCohRnbTfk5xxQAfQ4_yMVCu5a3WDQr+mg@mail.gmail.com>
Hi,
Do you have some restore_command in the recovery.conf of your replica ?
i.e.
restore_command = '/usr/bin/pgbackrest --stanza=demo archive-get %f "%p"'
On 01/11/2018 10:37 AM, Aldo Sarmiento wrote:
> I have streaming replication setup between a master/slave. The other
> day the slave had some issues and couldn’t be brought up before WAL
> logs got archived via pgbackrest archive command. Is there a way to
> bring the replica up to date using the pg backrest archives so that I
> can start streaming again? Currently it’s complaining that the master
> doesn’t have the WAL logs in pg_xlog directory to do so. Thank you, Aldo
--
Stefan FERCOT
http://dalibo.com - http://dalibo.orgAttachments:
signature.asc (application/pgp-signature, 487B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: stefan.fercot@dalibo.com, aldo@bigpurpledot.com
Subject: Re: PG backrest restore
In-Reply-To: <a9a1fbec-e0b1-0fe2-1367-9050a2c2ab77@dalibo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox