Postgres Pro
Downloads
Home   >   mailing lists

Re: Backup Restore from other node after switchover/failover - Mailing list pgsql-general

From Sushant Pawar
Subject Re: Backup Restore from other node after switchover/failover
Date
Msg-id CAF2=t-oOtDrJsAFEX12XXMtmj+_6R+drAgJ-21zHeN=q+kRtRQ@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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.Krautschick@trivadis.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

pgsql-general by date:

Previous
From: Matthias Apitz
Date:
Subject: Re: facing problem in outparameters in c
Next
From: "Zwettler Markus (OIZ)"
Date:
Subject: pgpool-II native replication