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