Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

MySQL to Postgres migration for metastore,Navigator,SCM

MySQL to Postgres migration for metastore,Navigator,SCM

Folks, We are currently using external mysql db for storing hive metastore,oozie,scm,nav,navms data etc , which we now need to migrate to a postgres instance. Could you please help me with steps,pointers for such migration please. Any utility that does this? Thanks in advance. Regards Suresh

1 REPLY 1

Re: MySQL to Postgres migration for metastore,Navigator,SCM

Expert Contributor

There is no ready made utility, you will have to look into external utilities for the database migration. See https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL

Don't have an account?
Coming from Hortonworks? Activate your account here