From: | Sushant Pawar <sushantxp(at)gmail(dot)com> |
---|---|
To: | Dirk Krautschick <Dirk(dot)Krautschick(at)trivadis(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Backup Restore from other node after switchover/failover |
Date: | 2020-10-28 12:22:17 |
Message-ID: | CAF2=t-oOtDrJsAFEX12XXMtmj+_6R+drAgJ-21zHeN=q+kRtRQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Hi Dirk,
Yes, this will work fine. You can use the existing backup to restore it on
the new node and use the WAL archives from new node for the recovery
purpose. As a best practice, I would suggest setting the parameter
"recovery_target_timeline=latest" in your recovery command to ensure the
recovery happens along the latest timeline.
Regards
Sushant
On Wed, Oct 28, 2020 at 2:53 PM Dirk Krautschick <
Dirk(dot)Krautschick(at)trivadis(dot)com> wrote:
> Hi,
>
>
>
> haven’t tested it yet but maybe I can get a quick answer here.
>
> We have discussed the following scenario.
>
>
>
> Few nodes as streaming replication cluster all in sync with taking backup
>
> only from one dedicated node. Now that node which is responsible for the
> backups
>
> goes down. For sure I have a full backup taken from that crashed node
>
> some time ago but now this node is gone and I have to take care for a
>
> restore for some reason.
>
>
>
> Am I able to make a full restore with that last backup from the offline
> node
>
> to any other still existing node with Recovering the archived WAL from the
> new
>
> selected node if I have activated archive_mode as “always”?
>
>
>
> Or is it strictly necessary to create a new full backup from the new node
>
> which is responsible for the backups after the failover or maybe after a
>
> Switchover, too?
>
>
>
> Thanks and best regards
>
>
>
> Dirk
>
From | Date | Subject | |
---|---|---|---|
Next Message | srijith s | 2020-10-29 02:07:12 | Postgres windows binary |
Previous Message | Dirk Krautschick | 2020-10-28 09:22:47 | Backup Restore from other node after switchover/failover |
From | Date | Subject | |
---|---|---|---|
Next Message | Zwettler Markus (OIZ) | 2020-10-29 13:46:40 | pgpool-II native replication |
Previous Message | Matthias Apitz | 2020-10-28 10:39:14 | Re: facing problem in outparameters in c |