Configure Postgress HA database for Hive Metastore

[#1]

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?

[#2 · Accepted solution]

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.