Thread: restore_command for postgresql streaming replication

Greetings,

* Brajendra Pratap Singh (singh.bpratap766@gmail.com) wrote:
> Please help us to configure the restore_command on postgresql replication
> server's recovery.conf file incase of ERROR: requested wal segment has
> already been removed on primary and when we have implemented pgbackrest on
> primary database.
>
> Primary database -
>
> archive_command = 'pgbackrest --stanza=uatodb archive-push %p'

For this, the restore_command would be:

restore_command = 'pgbackrest --stanza=uatodb archive-get %f "%p"'

When you use pgbackrest to do a restore with 'pgbackrest restore',
pgbackrest will also write the correct restore_command into the
configuration for the restored system for you.

You might want to check out the user guide:

https://pgbackrest.org/user-guide.html

(that's for v10 on Debian, there's a couple other user guides if you're
on something different that you could look at)

Thanks,

Stephen