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