Search Postgresql Archives

Re: restore_command for postgresql streaming replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Greetings,

* Brajendra Pratap Singh (singh.bpratap766@xxxxxxxxx) 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

Attachment: signature.asc
Description: PGP signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux