Re: pgbackrest restore to new location?

On 9/17/19 4:29 AM, Luca Ferrari wrote:
> On Tue, Sep 17, 2019 at 3:09 AM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
>> Hi,
>>
>> In order to do this, do I create a new stanza in config file which has
>> pg1-path point to the new/empty directory structure while still pointing to
>> the existing backup directory, and restore that stanza?
> No, I would do this:
> 1) execute stop for that stanza on the backup machine
> 2) change the pg1-path for that stanza on the target machine
> 3) execute the restore command on the target machine
> 4) adjust backup machine stanza path and 'start' it again.
>
> If you create a new stanza, pgbackrest will not find it in the backup
> repository.

Thanks, Luca.  I realized that mistake when trying the restore.

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".

--
Angular momentum makes the world go 'round.