Message-ID: <56d23ec9-dc1f-e5a0-b2f9-59999abc5251@gmail.com>
Date: Tue, 27 Jun 2023 05:12:32 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.11.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>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: <81a5d38d-db54-30ff-0b7c-054a950c5641@pgmasters.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/56d23ec9-dc1f-e5a0-b2f9-59999abc5251%40gmail.com>
Precedence: bulk

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?

-- 
Born in Arizona, moved to Babylonia.