Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qE41p-0007QO-IG
	for pgsql-admin@arkaria.postgresql.org; Tue, 27 Jun 2023 08:26:25 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qE41o-0002jM-04
	for pgsql-admin@arkaria.postgresql.org; Tue, 27 Jun 2023 08:26:24 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <david@pgmasters.net>)
	id 1qE41n-0002jD-Lr
	for pgsql-admin@lists.postgresql.org; Tue, 27 Jun 2023 08:26:23 +0000
Received: from mail.thelabyrinth.net ([45.56.70.56])
	by magus.postgresql.org with esmtps  (TLS1.2) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <david@pgmasters.net>)
	id 1qE41l-000kNI-6L
	for pgsql-admin@lists.postgresql.org; Tue, 27 Jun 2023 08:26:23 +0000
Received: from [10.5.0.2] (unknown [185.187.243.175])
	(using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits))
	(No client certificate requested)
	(Authenticated sender: dsteele)
	by mail.thelabyrinth.net (Postfix) with ESMTPSA id 1DEB35465C;
	Tue, 27 Jun 2023 08:26:18 +0000 (UTC)
Message-ID: <81a5d38d-db54-30ff-0b7c-054a950c5641@pgmasters.net>
Date: Tue, 27 Jun 2023 10:26:16 +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: Deo Felix <deofelix9@gmail.com>, Ron <ronljohnsonjr@gmail.com>
Cc: 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>
From: David Steele <david@pgmasters.net>
In-Reply-To: 
 <CALW=F4PgGSJX-ix0NgbD4XFCezt5ZNTDvTLvJUG0yR89z08tog@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/81a5d38d-db54-30ff-0b7c-054a950c5641%40pgmasters.net>
Precedence: bulk

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.

Regards,
-David