Skip to main content
Solved

How to restore PostgreSQL Cluster from FSBasedBackupSet


Forum|alt.badge.img+3

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?

Best answer by Meera

Hi Tony,

Till sp34, restore to single node is only supported. It will bring up the instance as a regular instance. Replication need 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)

 

 

View original
Did this answer your question?

4 replies

Meera
Vaulter
Forum|alt.badge.img+7
  • Vaulter
  • 68 replies
  • Answer
  • April 23, 2024

Hi Tony,

Till sp34, restore to single node is only supported. It will bring up the instance as a regular instance. Replication need 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)

 

 


Forum|alt.badge.img+3
  • Author
  • Byte
  • 6 replies
  • April 25, 2024
Meera wrote:

Hi Tony,

Till sp34, restore to single node is only supported. It will bring up the instance as a regular instance. Replication need 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?


Meera
Vaulter
Forum|alt.badge.img+7
  • Vaulter
  • 68 replies
  • April 25, 2024

Hi Tony,

For restore from dumpbased, master should be destination instance (since write to standby does not work) and it will not break replication. 

 


Forum|alt.badge.img+3
  • Author
  • Byte
  • 6 replies
  • April 25, 2024
Meera wrote:

Hi Tony,

For restore from dumpbased, master should be destination instance (since write to standby does not work) and it will not break replication. 

 

Thank you very much!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings