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 81a5d38d-db54-30ff-0b7c-054a950c5641@pgmasters.net
Whole thread Raw
In response to Re: Postgresql Database cant start after restore using pgBackRest  (Deo Felix <deofelix9@gmail.com>)
Responses Re: Postgresql Database cant start after restore using pgBackRest
Re: Postgresql Database cant start after restore using pgBackRest
List pgsql-admin
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



pgsql-admin by date:

Previous
From: David Steele
Date:
Subject: Re: Postgresql Database cant start after restore using pgBackRest
Next
From: Ron
Date:
Subject: Re: Postgresql Database cant start after restore using pgBackRest