Re: pgbackrest restore to new location?

From: David Steele <david(at)pgmasters(dot)net>
To: Luca Ferrari <fluca1978(at)gmail(dot)com>, Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgbackrest restore to new location?
Date: 2019-09-17 11:48:27
Message-ID: 47627a69-9899-1457-77ba-4bb547dadf69@pgmasters.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/17/19 7:23 AM, Luca Ferrari wrote:
> On Tue, Sep 17, 2019 at 12:00 PM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
>> The real problem is that after doing that, "pg_ctl start -D
>> /path/to/new/data" fails with "PANIC: could not locate a valid checkpoint
>> record".

Sounds like backup_label is missing or has been deleted.

The easiest way to restore to a new location is just to copy
pgbackrest.conf from the primary (or create a new one) with the same
stanza and then alter pg1-path in pgbackrest.conf or at the command line.

Regards,

--
-David
david(at)pgmasters(dot)net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ashkar Dev 2019-09-17 11:56:30 Re: PostgreSQL License
Previous Message Luca Ferrari 2019-09-17 11:23:59 Re: pgbackrest restore to new location?