Postgres Pro
Downloads
Home   >   mailing lists

Thread: PG backrest restore

PG backrest restore

From
Aldo Sarmiento
Date:
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

Re: PG backrest restore

From
Stefan Fercot
Date:

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