Support Questions
Find answers, ask questions, and share your expertise

Cloudera Manager JDBC Connection Issue

New Contributor

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

1 REPLY 1

Super Collaborator

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

Li Wang, Technical Solution Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Learn more about the Cloudera Community:

Terms of Service

Community Guidelines

How to use the forum