Re: pgbackrest restore to new location?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: David Steele <david(at)pgmasters(dot)net>
Cc: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgbackrest restore to new location?
Date: 2019-09-17 14:04:16
Message-ID: af253e5c-2754-c095-2521-7aad9ba35b35@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/17/19 6:48 AM, David Steele wrote:
> 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.

That's what I did.  (Also, I opened Issue #839 in GitHub  All of the log
files are attached there.)

--
Angular momentum makes the world go 'round.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rui DeSousa 2019-09-17 14:13:13 Re: max_connections parameter: too_many_connections error
Previous Message Tom Lane 2019-09-17 14:02:40 Re: pldbgapi extension