Message-ID: <634ceaf1-abb1-8bcc-f7a4-bb407f468a25@pgmasters.net>
Date: Tue, 27 Jun 2023 16:46:08 +0200
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0)
 Gecko/20100101 Thunderbird/102.12.0
Subject: Re: Postgresql Database cant start after restore using pgBackRest
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: 
 <CALW=F4MZsscvQ-x+fGmxSY2q4xaGk1stKPsKuts-om-ewdeR5A@mail.gmail.com>
 <484cbe3c-eb15-5327-df72-3338c17c7855@pgmasters.net>
 <29c782b4-9ae3-364d-bca9-44f48c340aa3@gmail.com>
 <CALW=F4PgGSJX-ix0NgbD4XFCezt5ZNTDvTLvJUG0yR89z08tog@mail.gmail.com>
 <81a5d38d-db54-30ff-0b7c-054a950c5641@pgmasters.net>
 <56d23ec9-dc1f-e5a0-b2f9-59999abc5251@gmail.com>
From: David Steele <david@pgmasters.net>
In-Reply-To: <56d23ec9-dc1f-e5a0-b2f9-59999abc5251@gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/634ceaf1-abb1-8bcc-f7a4-bb407f468a25%40pgmasters.net>
Precedence: bulk

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