Skip to main content
Solved

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

  • 8 March 2022
  • 2 replies
  • 1191 views

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?

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

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 

Terms & ConditionsCookie settings