Re: PG backrest restore - Mailing list pgsql-admin

From Stefan Fercot
Subject Re: PG backrest restore
Date
Msg-id a9a1fbec-e0b1-0fe2-1367-9050a2c2ab77@dalibo.com
Whole thread Raw
In response to PG backrest restore  (Aldo Sarmiento <aldo@bigpurpledot.com>)
List pgsql-admin

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.org
Attachment

pgsql-admin by date:

Previous
From: Aldo Sarmiento
Date:
Subject: PG backrest restore
Next
From: Ronnj Grotto
Date:
Subject: Using 9.6 client with 10.0 server