Informix to Postgresql via DBI-Link
Pedro Ferro <[email protected]> Thu, 28 Feb 2013 15:25:22 +0000
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <CAAp6FGM9=QPo9TypT3pdr=TedxMxMvvCdcTo+5QwVy=5RmahFg@mail.gmail.com> |
Hi, My main goal is to do a "select" in the Informix DB and be able to import that information directly into the DBPostgreSQL / PostGIS, from what I understand DBI-Link is the right tool for this. However I have a major problem and I can not install DBI-Link in Postgresql. I have a machine with OS Windows 64-bit . (I can not change that). As I understand I need to install first Active Perl on my machine, which I have done. However when I create a new extension (plperlu) in Postgresql gives me an error like: "can not load library: c: \ Program Files \ PostgreSQL \ 9.2 \ lib \ plperl.dll." I verified that the file plperl.dll exists in that exact location . As I investigated the problem could be related to the version of Active Perl installed and recommend installing version 5.10, which I did. However just found the version for 32 bits. (ActivePerl-5.10.1.1008-MSWin32-x86-294165.msi - advanced-shorturl-perl-pidgin - ActivePerl 5.10 - Advanced Shorturl in Perl for Pidgin - Google Project Hosting<http://code.google.com/p/advanced-shorturl-perl-pidgin/downloads/detail?name=ActivePerl-5.10.1.1008-MSWin32-x86-294165.msi> ) 1 - It seems to you that the indicated error may have to do with be using the 32-bit version of Active Perl? 1.1 - If so, does anyone know where I can get the version of Active Perl 5.10 64 bits? I don't have many computer skills so I can be doing a basic error that is preventing the installation of the DBI-Link in Postgresql even when following your tutorials I would appreciate your help because I'm stuck for several days with this problem and do not know how to solve it ... Regards, Pedro