From: Eugene Poole [mailto:etpoole60@xxxxxxxxxxx]
Sent: Tuesday, December 05, 2017 12:59 PM
To: pgsql-general@xxxxxxxxxxxxxx
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
