Re: Online Oracle to Postgresql data migration

From: "Josh Harrison" <joshques(at)gmail(dot)com>
To: "David Fetter" <david(at)fetter(dot)org>, "General postgres mailing list" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Online Oracle to Postgresql data migration
Date: 2008-01-14 16:42:50
Message-ID: 8d89ea1d0801140842r3955e2femcb60a04c777f1d86@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks

On Jan 12, 2008 9:19 AM, David Fetter <david(at)fetter(dot)org> wrote:

> On Fri, Jan 11, 2008 at 01:02:01PM -0500, Josh Harrison wrote:
> > Hi
> > We have an Oracle production database with some terbytes of data. We
> > wanted to migrate that to Postgresql (rigt now...a test database and
> > not production) database. What are the good options to do that?
>
> I have written some Free software, DBI-Link, for just this use case.
> The software is under the BSD license, so you can use it freely. I
> also offer consulting on such migrations.
>
I downloaded DBI-Link.
When I tried to compile postgres8.3 with-perl option it gives me this error.

ld: fatal: relocations remain against allocatable but non-writable sections
collect2: ld returned 1 exit status
gmake[3]: *** [libplperl.so.0.0] Error 1

My OS is SunOS 5.10
(The same compiles fine in FreeBSD but gives an error in Solaris). Is this
kind 0f solaris-specific error?

Do you know what caues this error?
Thanks
josh

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrej Ricnik-Bay 2008-01-14 17:04:42 Members-choice award at LinuxQuestions.org
Previous Message Tom Lane 2008-01-14 15:58:56 Re: Forgot to dump old data before re-installing machine