Re: restore_command for postgresql streaming replication - Mailing list pgsql-general

From Stephen Frost
Subject Re: restore_command for postgresql streaming replication
Date
Msg-id 20200702153252.GR3125@tamriel.snowman.net
Whole thread Raw
In response to restore_command for postgresql streaming replication  (Brajendra Pratap Singh <singh.bpratap766@gmail.com>)
List pgsql-general
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

Attachment

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Different results from identical matviews
Next
From: Tom Lane
Date:
Subject: Re: Different results from identical matviews