Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Configure Postgress HA database for Hive Metastore

avatar
Contributor

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?

1 ACCEPTED SOLUTION

avatar
Expert Contributor

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-configurat...

 

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. 

View solution in original post

1 REPLY 1

avatar
Expert Contributor

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-configurat...

 

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.