Re: Online Oracle to Postgresql data migration

["Josh Harrison" <joshques@xxxxxxxxx>]

On Jan 16, 2008 10:11 AM, Josh Harrison <joshques@xxxxxxxxx> wrote:

On Jan 15, 2008 3:58 PM, David Fetter <david@xxxxxxxxxx> wrote:

On Mon, Jan 14, 2008 at 11:42:50AM -0500, Josh Harrison wrote:
> Thanks
>
> On Jan 12, 2008 9:19 AM, David Fetter <david@xxxxxxxxxx> 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.

You may have an old or broken version of perl.  What's the output of
perl -v?

I use version 5.8.8
Thanks. I sorted out that. That was a linker problem. I installed binutils and made gcc use that ld. Now I can compile postgres with perl option.

Now a new problem had come up. When I try createlang command
createlang plperlu test
I get this error...
createlang: language installation failed: ERROR:  could not load library "/export/home/josh/postgres8.3-perl/lib/plperl.so": ld.so.1: postgres: fatal: relocation error: file /export/home/josh/postgres8.3-perl/lib/plperl.so: symbol PL_curpad: referenced symbol not found

perl information:
 perl -v
This is perl, v5.8.8 built for i86pc-solaris-64int

Can you advise pls
josh