Re: Postgresql Database cant start after restore using pgBackRest

On 6/27/23 12:12, Ron wrote:
> On 6/27/23 03:26, David Steele wrote:
>> On 6/27/23 07:41, Deo Felix wrote:
>>> In the postgresql.auto.conf i have this configs
>>> restore_command = 'pgbackrest --pg1-path=/var/lib/postgres/main
>>> --stanza=data archive-get %f "%p"'
>>> recovery_target = 'immediate'
>>> recovery_target_timeline = 'current'
>>>
>>> But still I the database cant start
>>
>> You will need to redo your pgbackrest restore with
>> --target-timeline=current and then restart postgres to start recovery
>> with the correct settings.
>
> Is this standard procedure for an "in place" --delta restore?

No -- this is mitigation for the split-brain situation which was causing
the OP's recovery error.

Regards,
-David