On Jan 16, 2008 1:43 PM, Josh Harrison <[EMAIL PROTECTED]> wrote: > > > On Jan 16, 2008 10:11 AM, Josh Harrison <[EMAIL PROTECTED]> wrote: > > > > > > > On Jan 15, 2008 3:58 PM, David Fetter <[EMAIL PROTECTED]> wrote: > > > > > On Mon, Jan 14, 2008 at 11:42:50AM -0500, Josh Harrison wrote: > > > > Thanks > > > > > > > > On Jan 12, 2008 9:19 AM, David Fetter <[EMAIL PROTECTED]> 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