How to restore PostgreSQL Cluster from FSBasedBackupSet

Question

Hello,We are running commvault 11.28.52 and currently testing the PostgtreSQL Agent. In our testing environment, we have two PostgreSQL 12 Servers running as a cluster with one Primary active server and one standby server. The servers are Linux-based VMs.We are performing backups and restores from the primary server. However, every time we restore the DB from the FSBasedBackupSet, the replication between the nodes stops working. What are the Best Practices for FsBased cluster restore and how to perform restore correctly from this backupset?

Meera · Accepted Answer

Hi Tony,Till sp34, restore to single node is only supported. It will bring up the instance as a regular instance. Replicationneed to be established manually. Advantage is backup can be offloaded to standby client.From sp34, restore as cluster is supported. Please see these links for more details.Creating PostgreSQL Cluster Client (Pseudo-client) (commvault.com)FSBased In-place Restore Type (commvault.com)

tonytony · Answer

Hi Tony,Till sp34, restore to single node is only supported. It will bring up the instance as a regular instance. Replicationneed to be established manually. Advantage is backup can be offloaded to standby client.From sp34, restore as cluster is supported. Please see these links for more details.Creating PostgreSQL Cluster Client (Pseudo-client) (commvault.com)FSBased In-place Restore Type (commvault.com)Thank you for the resposne?Does the restore from DumpBasedBackupSet also breaks replication?

How to restore PostgreSQL Cluster from FSBasedBackupSet

4 replies

Reply

Reply

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded