Re: pgbackrest restore to new location?

2019-09-18 Thread Stephen Frost
Greetings, * David Steele (da...@pgmasters.net) wrote: > On 9/17/19 10:03 PM, Stephen Frost wrote: > > I'll get a patch into the next commitfest to remove it. The exclusive > > method has been deprecated for quite a few releases and we should stop > > giving bad advice on the assumption that peop

Re: pgbackrest restore to new location?

2019-09-18 Thread David Steele
On 9/17/19 10:03 PM, Stephen Frost wrote: > > That said- it brings up a pretty serious issue that should be discussed, > and that's nuking this: > > HINT: If you are not restoring from a backup, try removing the file > ".../backup_label". > > That hint is absolutely wrong these days when many

Re: pgbackrest restore to new location?

2019-09-17 Thread Stephen Frost
Greetings, * Ron (ronljohnso...@gmail.com) wrote: > 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 wrote: > >>>The real problem is that after doing that, "pg_ctl start -D > >>>/path/to/new/data" fails with "PANIC: could

Re: pgbackrest restore to new location?

2019-09-17 Thread Ron
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 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 i

Re: pgbackrest restore to new location?

2019-09-17 Thread David Steele
On 9/17/19 7:23 AM, Luca Ferrari wrote: > On Tue, Sep 17, 2019 at 12:00 PM Ron 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. T

Re: pgbackrest restore to new location?

2019-09-17 Thread Luca Ferrari
On Tue, Sep 17, 2019 at 12:00 PM Ron 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". Hard to say what's going wrong without logs/configs. Do you have any other backup to try to restore from

Re: pgbackrest restore to new location?

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

Re: pgbackrest restore to new location?

2019-09-17 Thread Luca Ferrari
On Tue, Sep 17, 2019 at 3:09 AM Ron 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 sto

pgbackrest restore to new location?

2019-09-16 Thread Ron
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? Thanks -- Angular momentum makes the world go 'round.