Configure Postgress HA database for Hive Metastore

KPG1 — Tue, 21 Apr 2026 07:46:26 GMT

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?

Re: Configure Postgress HA database for Hive Metastore

arunek95 — Fri, 23 Dec 2022 01:33:15 GMT

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.

question Re: Configure Postgress HA database for Hive Metastore in Support Questions

Configure Postgress HA database for Hive Metastore

Re: Configure Postgress HA database for Hive Metastore