| From: | Stefan Fercot <stefan(dot)fercot(at)dalibo(dot)com> |
|---|---|
| To: | Aldo Sarmiento <aldo(at)bigpurpledot(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: PG backrest restore |
| Date: | 2018-01-11 09:41:35 |
| Message-ID: | a9a1fbec-e0b1-0fe2-1367-9050a2c2ab77@dalibo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ronnj Grotto | 2018-01-11 10:14:37 | Using 9.6 client with 10.0 server |
| Previous Message | Aldo Sarmiento | 2018-01-11 09:37:10 | PG backrest restore |