Re: [GENERAL] Move From Oracle DB to PostgreSQL DB

2011-03-14 Thread Tom Lane
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= writes: > On Mon, 2011-03-14 at 14:43 -0400, gene.po...@macys.com wrote: >> [ wants to port Red Hat Satellite to Postgres ] > Please see > http://spacewalk.redhat.com/ Yeah. I'm on the fringes of that port effort, and it is *not* trivial; Satellite is umpteen

Re: [GENERAL] Move From Oracle DB to PostgreSQL DB

2011-03-14 Thread John R Pierce
On 03/14/11 11:43 AM, gene.po...@macys.com wrote: Is there a recent tutorial, white paper, how to on move/migrate from Oracle to PostgreSQL? I can get the Oracle schema DDL by pointing our Data Modeling software at the Red Hat Satellite server and extracting the DDL. It will take that Oracle

Re: [GENERAL] Move From Oracle DB to PostgreSQL DB

2011-03-14 Thread Stephen Frost
Gene, * gene.po...@macys.com (gene.po...@macys.com) wrote: > Is there a recent tutorial, white paper, how to on move/migrate from > Oracle to PostgreSQL? It's typically "not hard", but it depends on what you're doing w/ Oracle. Specifically, things like stored procedures (PL/SQL) may require

Re: [GENERAL] Move From Oracle DB to PostgreSQL DB

2011-03-14 Thread Andrew Sullivan
On Mon, Mar 14, 2011 at 02:43:17PM -0400, gene.po...@macys.com wrote: > Is there a recent tutorial, white paper, how to on move/migrate from > Oracle to PostgreSQL? I can get the Oracle schema DDL by pointing our > Data Modeling software at the Red Hat Satellite server and extracting the > DDL

Re: [GENERAL] Move From Oracle DB to PostgreSQL DB

2011-03-14 Thread Devrim GÜNDÜZ
On Mon, 2011-03-14 at 14:43 -0400, gene.po...@macys.com wrote: > We're running Red Hat Satellite Server and it's used to provision our > servers (both physical and virtual). It works great and we have no > issues with it *except* It will only provision Red Hat. > > Why this question: > > We

[GENERAL] Move From Oracle DB to PostgreSQL DB

2011-03-14 Thread gene . poole
Just a little background: We're running Red Hat Satellite Server and it's used to provision our servers (both physical and virtual). It works great and we have no issues with it *except* It will only provision Red Hat. Why this question: We've been directed by our management to examine the