Skip site navigation (1) Skip section navigation (2)

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

From: Walter Hurry <walterhurry(at)lavabit(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64
Date: 2011-12-07 15:43:22
Message-ID: jbo1iq$9sq$1@dough.gmane.org (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-novice
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.


In response to

pgsql-novice by date

Next:From: Alan HodgsonDate: 2011-12-07 20:26:13
Subject: Re: Linux server connection process consumes all memory
Previous:From: Tomas VondraDate: 2011-12-07 14:36:16
Subject: Re: [GENERAL] Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64

pgsql-admin by date

Next:From: Chris HooverDate: 2011-12-07 17:04:33
Subject: Question about multiple slaves and Master loss.
Previous:From: Tomas VondraDate: 2011-12-07 14:36:16
Subject: Re: [GENERAL] Convert / Migrate From Oracle 11gR2 To PostgreSQL ? On CentOS 5.7 x86_64

pgsql-general by date

Next:From: Scott MarloweDate: 2011-12-07 15:47:14
Subject: Re: making "\pset pager off" the default
Previous:From: C├ędric VillemainDate: 2011-12-07 15:19:10
Subject: Re: is there example of update skript?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group