Question

Postgresql Patroni Cluster backup

  • 14 December 2022
  • 8 replies
  • 747 views

Userlevel 1
Badge +5

I was looking for documentation on how to configure backup for multi node postgresql cluster and came across above community question.

It was mentioned that plans are there for supporting this config (post is 9 months old)

Is it in support now? 


8 replies

Userlevel 7
Badge +23

Tagging in @Meera to confirm.

Userlevel 3
Badge +7

Hi Shailu,

It is not yet supported. 

 

Regards,

Meera

Userlevel 7
Badge +19

So, I assume it would help to open a CMR so PM can prioritize the backlog accordingly, right? 

Userlevel 3
Badge +7

Yes, please open a CMR/CCR

Badge +1

Hi Meera,

 

Will the backup work in case of multi nodes deployment (more than one standby), but in CV agent the customer will define only one Master and One passive node? Thanks

Userlevel 5
Badge +12

Hi Meera,

 

Will the backup work in case of multi nodes deployment (more than one standby), but in CV agent the customer will define only one Master and One passive node? Thanks

Hi @Dshochat 

Yes, that will work. We can’t configure the instance with more than two nodes.

 

Thanks,

Sunil-

Badge +2

@Sunil : quick question
In the PR2023 documentation (https://documentation.commvault.com/2023/expert/149133_changes_in_commvault_platform_release_2023.html) the following is stated:

You can protect PostgreSQL data using multiple standby cluster instances.

Previously, only one master-standby server pair was supported.

This does mean that one master and multiple standby servers can be configured once an environment is upgraded to Platform Release 2023 ?

 

Userlevel 5
Badge +12

@Sunil: quick question
In the PR2023 documentation (https://documentation.commvault.com/2023/expert/149133_changes_in_commvault_platform_release_2023.html) the following is stated:

You can protect PostgreSQL data using multiple standby cluster instances.

Previously, only one master-standby server pair was supported.

This does mean that one master and multiple standby servers can be configured once an environment is upgraded to Platform Release 2023 ?

 

Hi @Patrick 

Yes, it’s controlled by an additional setting. More details are here. 

https://documentation.commvault.com/2023/expert/154481_configuring_multiple_standby_cluster_instances_for_postgresql.html

Reply