Re: Postgresql Database cant start after restore using pgBackRest - Mailing list pgsql-admin

From David Steele
Subject Re: Postgresql Database cant start after restore using pgBackRest
Date
Msg-id 634ceaf1-abb1-8bcc-f7a4-bb407f468a25@pgmasters.net
Whole thread Raw
In response to Re: Postgresql Database cant start after restore using pgBackRest  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
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



pgsql-admin by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Why log_statement may not work for a particular database?
Next
From: Deo Felix
Date:
Subject: Re: Postgresql Database cant start after restore using pgBackRest