Re: Postgresql Database cant start after restore using pgBackRest

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Postgresql Database cant start after restore using pgBackRest
Date: 2023-06-27 10:12:32
Message-ID: 56d23ec9-dc1f-e5a0-b2f9-59999abc5251@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Janes 2023-06-27 11:49:32 Re: Why log_statement may not work for a particular database?
Previous Message David Steele 2023-06-27 08:26:16 Re: Postgresql Database cant start after restore using pgBackRest