Re: Online Oracle to Postgresql data migration

On Jan 16, 2008 10:11 AM, Josh Harrison <joshques(at)gmail(dot)com> wrote:

>
>
> On Jan 15, 2008 3:58 PM, David Fetter <david(at)fetter(dot)org> 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(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.
> >
> > 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