Skip to main content
KPG1
Gold ⭐️
December 13, 2022
Solved

Configure Postgress HA database for Hive Metastore

Hi All,

I am using  Postgress for Hive metastore

How can we configure postgress HA with Hive with true HA on the Hive Metastore without changing the connection string manually?

arunek95
arunek95Answer
Gold ⭐️
December 23, 2022

Hi @KPG1 , As per the description I believe you are looking for a way to have a high availability for HMS , if that is the case please find the below doc which can help - 

 

https://docs.cloudera.com/cdp-private-cloud-upgrade/latest/upgrade-cdh/topics/hive-hms-ha-configuration.html

 

And for the backend DB to configure it for HA , it will be out of scope of Cloudera and you have to work with DB team itself to understand how they can configure. 

1 reply

arunek95
Gold ⭐️
arunek95Answer
Gold ⭐️
December 23, 2022

Hi @KPG1 , As per the description I believe you are looking for a way to have a high availability for HMS , if that is the case please find the below doc which can help - 

 

https://docs.cloudera.com/cdp-private-cloud-upgrade/latest/upgrade-cdh/topics/hive-hms-ha-configuration.html

 

And for the backend DB to configure it for HA , it will be out of scope of Cloudera and you have to work with DB team itself to understand how they can configure. 

Translate