Re: [GENERAL] Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64

On December 7, 2011, 09:36:20 AM, Tomas Vondra wrote:
> Not sure why you're doing this, but you can do something similar with
> PostgreSQL. Running four clusters using the same set of binaries is not
a
> big deal.
>
> Although this is a PostgreSQL list, I'll point out the limit is 11GB
with
> the current Oracle XE version (11g).
>
> PostgreSQL Community Edition? What is that? Do you mean sources that are
> available for download from postgresql.org?
>
> Switching the database in the AS is not a big deal - there's usually a
> connection pool, so you need to add PostgreSQL JDBC driver and change
the
> config.
>
> Porting the application is usually much harder, especially if you use
> features that are available on Oracle only (or if you're hurt by some
> Oracle-ism). If you're using native SQL, PL/SQL, etc. you'll have to
> rewrite that. The complexity really depends on how your application is
> coded, it's impossible to judge this.
>
> Anyway, the simplest thing you can do is to give it a try. Install
> PostgreSQL on a development environment and try to run the application.
> It'll probably fail for some reason - fix the issue and repeat.
>
> There are tools to make the switch easier - e.g. orafce package that
> provides some compatibility features.
>

I guess I didn't explain well enough. I absolutely do not need any Oracle
help, I've a whole team of people at work I can get that information from.
I listed where I am, why I cannot go to the free Oracle (size
limitations), and where I would like to end up (PostgreSQL).

What I'm asking is how to get there and what is the best version of
PostgreSQL to use. Where can I find a 'How To Use PostgreSQL For A Oracle
DBA' type manual. Maybe some tutorials. 'How do I build a PostgreSQL
database that mimics my current Oracle database' type document is what I'm
looking for.

For this type of application I rarely use a RPM. I normally use a ZIP or
tar ball so I can control where it is installed (binaries on one disk,
data on another disk, and the index on yet another disk) how it
configured. OK, I'm a control freak! But that is why I use Linux.

Thanks,
Gene Poole

+ It's impossible for everything to be true. +