Re: Online Oracle to Postgresql data migration

["Josh Harrison" <joshques@xxxxxxxxx>]

On Jan 16, 2008 1:43 PM, Josh Harrison <joshques@xxxxxxxxx> wrote:

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

Forgot to mention......
My perl information
perl -V
Summary of my perl5 (revision 5 version 8 subversion 8) configuration:
  Platform:
    osname=solaris, osvers=2.10, archname=i86pc-solaris-64int
    uname='sunos aishwarya 5.10 generic_118844-26 i86pc i386 i86pc '
    config_args='-Dcc=gcc -Dprefix=/export/home/josh/perl5 -Duse64bitint -Duseshrplib'
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
    useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
    use64bitint=define use64bitall=undef uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='gcc', ccflags ='-fno-strict-aliasing -pipe -Wdeclaration-after-statement -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPERL_USE_SAFE_PUTENV -DPERL_USE_SAFE_PUTENV -DPERL_USE_SAFE_PUTENV -DPERL_USE_SAFE_PUTENV -DPERL_USE_SAFE_PUTENV -DPERL_USE_SAFE_PUTENV -DPERL_USE_SAFE_PUTENV',
    optimize='-O',
    cppflags='-fno-strict-aliasing -pipe -Wdeclaration-after-statement'
    ccversion='', gccversion='3.4.5', gccosandvers='solaris2.8'
    intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=12345678
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
    ivtype='long long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
    alignbytes=4, prototype=define
  Linker and Libraries:
    ld='gcc', ldflags =' -L/usr/local/lib '
    libpth=/usr/local/lib /usr/lib /usr/ccs/lib
    libs=-lsocket -lnsl -ldl -lm -lc
    perllibs=-lsocket -lnsl -ldl -lm -lc
    libc=/lib/libc.so, so=so, useshrplib=true, libperl=libperl.so
    gnulibc_version=''
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' -Wl,-E -R /export/home/josh/perl5/lib/5.8.8/i86pc-solaris-64int/CORE'
    cccdlflags='-fPIC', lddlflags=' -Wl,-E -G -L/usr/local/lib'


Characteristics of this binary (from libperl):
  Compile-time options: PERL_MALLOC_WRAP PERL_USE_SAFE_PUTENV
                        USE_64_BIT_INT USE_LARGE_FILES USE_PERLIO
  Built under solaris
  Compiled at Jan 16 2008 12:13:26
  @INC:
    /export/home/josh/perl5/lib/5.8.8/i86pc-solaris-64int
    /export/home/josh/perl5/lib/5.8.8
    /export/home/josh/perl5/lib/site_perl/5.8.8/i86pc-solaris-64int
    /export/home/josh/perl5/lib/site_perl/5.8.8
    /export/home/josh/perl5/lib/site_perl