Solved

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

  • 8 March 2022
  • 2 replies
  • 1117 views

Badge +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?

icon

Best answer by Meera 8 March 2022, 12:33

View original

If you have a question or comment, please create a topic

2 replies

Userlevel 3
Badge +7

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

Badge +5

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