Support Questions

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

Migrate cloudera manager database in CDH-6.3.x cluster from MySQL to external postgresql database

avatar
New Contributor

We want to migrate cloudera manager and various cloudera service database in CDH-6.3.x cluster from MySQL to External postgresql database. 
Need help with the steps to perform the same. 

1 REPLY 1

avatar
Expert Contributor

Hi @cloudera-a ,

 

Since the CM server ships with embedded PostgreSQL DB, our docs point to migrating from PSQL to MySQL or even Oracle, but not the other way around.

 

For instance, here's our doc to migrate from a PostgreSQL Database Server to a MySQL/Oracle Database Server [0].

 

You could make use of a 3rd party tool to achieve what you're trying to do, but this won't be encouraged by Cloudera, as this could easily lead to an unstable cluster.

 

[0] = Migrate from the Cloudera Manager External PostgreSQL Database Server to a MySQL/Oracle Database Ser...