Skip to main content
Solved

Is a Postgresql Paroni cluster backup supported under CV, howto configure, howto Backup?


Forum|alt.badge.img+5

My customer setup a Postgresql Patroni cluster. I found this description

 Patroni : Setting up a highly available PostgreSQL Cluster - CYBERTEC (cybertec-postgresql.com)

If he backup one of the passiv nodes he got “Could not put the Cluster in backup mode”

PostGresBackupParent.log

AnalyzeResult() - eRRoR --  PQresultStatus indicates failure for SELECT pg_start_backup('name'). Error:ERROR:  recovery is in progress

I would say it is the nature of a “not master” node to be in recovery status.

Backup of master node cause no issues.

I found no document in BOL how to configure a patroni cluster or howto backup it.

Is it supported?

Best answer by Meera

Hi Joerg,

 

Patroni cluster is not supported as such. If it’s a single standby-master configuration, standby feature can be used to perform backup/restore from passive node. 

https://documentation.commvault.com/11.24/expert/93037_back_up_from_standby_server.html

https://documentation.commvault.com/11.24/essential/114367_configuring_postgresql_database_instance_to_run_backup_operations_on_standby_server.html

 

Otherwise please take backup from master. Multiple standby configuration is not supported by commvault yet. We have plans to add support in future. How many nodes are there in customer setup? 

 

Regards,

Meera

View original
Did this answer your question?
If you have a question or comment, please create a topic

2 replies

Meera
Vaulter
Forum|alt.badge.img+7
  • Vaulter
  • 70 replies
  • Answer
  • March 8, 2022

Hi Joerg,

 

Patroni cluster is not supported as such. If it’s a single standby-master configuration, standby feature can be used to perform backup/restore from passive node. 

https://documentation.commvault.com/11.24/expert/93037_back_up_from_standby_server.html

https://documentation.commvault.com/11.24/essential/114367_configuring_postgresql_database_instance_to_run_backup_operations_on_standby_server.html

 

Otherwise please take backup from master. Multiple standby configuration is not supported by commvault yet. We have plans to add support in future. How many nodes are there in customer setup? 

 

Regards,

Meera


Forum|alt.badge.img+5
  • Author
  • Byte
  • 20 replies
  • March 8, 2022

Hi Meera,

Thanks for the fast answer.

Customer describes the cluster as three node construct but I am not sure if in this environment the monitoring is one part.

Kind regards

Joerg 


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