On 9/17/19 4:29 AM, Luca Ferrari wrote:
On Tue, Sep 17, 2019 at 3:09 AM Ron <ronljohnsonjr@xxxxxxxxx> 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.
