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.