Re: Postgresql Database cant start after restore using pgBackRest

From: David Steele <david(at)pgmasters(dot)net>
To: Deo Felix <deofelix9(at)gmail(dot)com>, Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Postgresql Database cant start after restore using pgBackRest
Date: 2023-06-27 08:26:16
Message-ID: 81a5d38d-db54-30ff-0b7c-054a950c5641@pgmasters.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2023-06-27 10:12:32 Re: Postgresql Database cant start after restore using pgBackRest
Previous Message David Steele 2023-06-27 08:24:41 Re: Postgresql Database cant start after restore using pgBackRest