question Re: Is it possible to migrate the Postgres db to Oracle for Cloudera 5.13.3? in Support Questions

Is it possible to migrate the Postgres db to Oracle for Cloudera 5.13.3?

reca — Wed, 29 Sep 2021 14:05:44 GMT

I have a cluster that uses a Postgres db with version 9.4.17 installed on a host in the cluster and I want to migrate to an external Oracle db. I have researched about the methods to do this in Cloudera documentations and I found that I have to have a Cloudera version higher than 5.15. Would it make any difference if we do the migration using Cloudera 5.13? what could be the differences between 5.13 and 5.15 in terms of db?

"""Configuration uses Cloudera Manager 5.15.0 or later on supported platforms."""

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_mysql.html

Re: Is it possible to migrate the Postgres db to Oracle for Cloudera 5.13.3?

GangWar — Fri, 01 Oct 2021 04:21:56 GMT

@reca This should work. The Oracle Database earlier versions are supported for C5.13. Please see the support matrix here.

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_mysql.html

Once you decide the Oracle DB version you can just follow this guide for migrating a Postgres DB to Oracle.

https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_mysql.html

Re: Is it possible to migrate the Postgres db to Oracle for Cloudera 5.13.3?

salpeyton — Mon, 04 Oct 2021 02:17:07 GMT

@GangWar wrote:
@reca This should work. The Oracle Database earlier versions are supported for C5.13. Please see the support matrix here.
https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_mysql.html
png to ico
Once you decide the Oracle DB version you can just follow this guide for migrating a Postgres DB to Oracle.
https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_ag_migrate_postgres_db_to_oracle_mysql.html

Thanks for the info, much appreciated!

Re: Is it possible to migrate the Postgres db to Oracle for Cloudera 5.13.3?

VidyaSargur — Mon, 04 Oct 2021 05:38:36 GMT

@reca, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.