To: pgsql-admin@postgresql.org
From: Walter Hurry <walterhurry@lavabit.com>
Subject: Re: Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS
	5.7 x86_64
Date: Wed, 7 Dec 2011 15:43:22 +0000 (UTC)
Lines: 32
Message-ID: <jbo1iq$9sq$1@dough.gmane.org>
References: 
 <OF1A68A015.B20F9DC9-ON8525795F.004C55AB-8525795F.004E18D9@MACYS.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
User-Agent: Pan/0.135 (Tomorrow I'll Wake Up and Scald Myself with Tea; GIT
	30dc37b master)

On Wed, 07 Dec 2011 09:13:10 -0500, Gene Poole wrote:

> This has to do with my personal home environment.
> 
> I'm running Oracle 11gR2 DBMS with 4 instances using a single home
> directory.  For each of the instances I'm using LVM file systems with 10
> logical volumes defined (/dbmsu00 used for the install and /dbmsu01 -
> u09 for the required files created using the DBCA utility). A single
> LISTENER created using the NETCA utility.
> 
> I chose Oracle because back in the dark ages I was a Oracle DBA when
> Oracle 7.3 was current. I've been told that it's OK to download and use
> the Oracle DBMS in a noncommercial environment for a limited time - well
> it's reached the end of that time.  I can't use the free Oracle XE
> because the database size limitations (4 GB).
> 
> Based upon what I've read and seen, the best choice for me is PostgreSQL
> Community Edition. What I need is advice, documentation, and information
> on how to take the above and move it from Oracle to PostgreSQL along
> with updating my JBoss 6.0 environment so it has access to the
> PostgreSQL databases/instances?  Can someone supply me with some
> direction?

I use PostgreSQL at home from *choice* (I am an Oracle DBA at work). But 
I don't think there is any time limit on personal non-commercial use of 
Oracle EE (you may want to check the OTN Licence Agreement on their  
download page).

PostgreSQL is FOSS, so there are no "Editions", by the way.

Lastly, a couple of polite requests: Please do not post HTML, and please 
consider carefully before crossposting to multiple groups.