Backup Restore from other node after switchover/failover

2020-11-09 Thread Dirk Krautschick
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

Re: Backup Restore from other node after switchover/failover

2020-10-28 Thread Sushant Pawar
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 recov