Cloudera Manager JDBC Connection Issue

[#1]

I'm new with managing Cloudera, set it up on a 4-host setup, CentOS 7, Cloudera 6.2.  Things work fine for a few hours but eventually the embedded Postgres stops working, when I try to log into Cloudera Manager I get "Unable to acquire JDBC Connection".

I set up a separate postgresql server, though even following these steps:

https://docs.cloudera.com/documentation/enterprise/6/6.2/topics/prepare_cm_database.html

the installation still uses the embedded Postgresql.

During cluster setup I can successfully direct Hue, Oozie (& Hive?) over to the separate postgresql server.

Advice?  I'm thinking it's an issue of too many connections, though am not yet able to locate how to try increasing the connection limit on the embedded postgresql (or to have it successfully use the separate postgresql server).

[#2]

Hi @agiese ,

Thanks for reaching out to Cloudera community!

You can follow this documentation on how to migrate from Embedded PostgreSQL Database Server to an External PostgreSQL Database:

https://docs.cloudera.com/documentation/enterprise/6/6.2/topics/cm_ag_migrate_postgres_db.html

Thanks and hope this helps!

Li