Re: Online Oracle to Postgresql data migration

On Jan 16, 2008 1:43 PM, Josh Harrison <joshques(at)gmail(dot)com> wrote:

>
>
> 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
>
> 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