Re: pgbackrest restore to new location?

From: Luca Ferrari <fluca1978(at)gmail(dot)com>
To: 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 09:29:46
Message-ID: CAKoxK+7cr=Eykr7ygAToYEAUMQ35aLH0-4mFkar_oNA3pGFJ2w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Luca

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message stan 2019-09-17 09:31:26 Re: FW: Re: FW: Re: Shouldn;t this trigger be called?
Previous Message Prakash Ramakrishnan 2019-09-17 06:51:36 pldbgapi extension