RE: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ??

From: Eugene Poole [mailto:etpoole60(at)comcast(dot)net]
Sent: Tuesday, December 05, 2017 12:59 PM
To: pgsql-general(at)postgresql(dot)org
Subject: Migrating From CentOS-6 Oracle 11g R2 To CentOS-7 PostgreSQL ??

I've asked most of my OS based questions on another mail list, but I think this is more specific:

On a physical machine I'm running CentOS-6 64-bit with Oracle 11gR2 and I want to migrate to another physical machine running CentOS-7 64-bit with PostgreSQL ??

1. What version of PostgreSQL should I use?

The latest that works for you. Some people don’t like .0 releases for various reasons and if that applies to you, then use the latest of 9.6.x (9.6.5 I think); else use 10.0.

2. I don't want to use a RPM because I like controlling where software is installed, so where can I locate the required tar ball?

You can download the source and build it yourself; there’s an arg for where you want to install it. The instructions are pretty easy to follow if you’ve ever built anything.

3. Would I use ora2pg do do the move? Is ora2pg still maintained?

4. Is there a better conversion package?

5. What additional information might be helpful?

I find building & testing on a VM to be useful, as I can snapshop every step of the way and revert if required. I’ve never done an Oracle -> Pg conversion, but it’s been discussed on the list so you might want to search the archives for advice. In fact the last time wasn’t all that long ago, maybe a month?

HTH, Kevin

TIA

Gene

--

Eugene Poole

Woodstock, Georgia

This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential information. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, distribution, review, copy or use of any of the information contained in or attached to this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify us by reply e-mail, and destroy the original transmission and its attachments without reading them or saving them to disk. Thank you.