plperl.dll error from create langauge plperl (XP Pro 64 bit)
All,
I am building an XP Pro 64 bit system, where I have installed the latest
PostgreSQL binary distribution (8.2.5-1). Everything loaded fine, I have
postgres up and running as a service, installed ActiveTcl and
ActivePerl, enabled PostGIS, etc. I can do the CREATE LANGUAGE 'pgtcl'
successfully, but I get the following error when I try to CREATE
LANGUAGE 'plperl'
ERROR: could not load library "C:/Program Files
(x86)/PostgreSQL/8.2/lib/plperl.dll": %1 is not a valid Win32
application.
Has anyone encountered this error with the binary install in question,
or has anyone attempted on XP Pro 64 bit? If this is a 32 vs 64 bit
issue, our plan is to eventually run on a 32 bit version, but 64 bit is
all I currently have access to.
Thanks,
Doug Knight
WSI Corp
Andover, MA, USA
Doug Knight wrote:
All,
I am building an XP Pro 64 bit system, where I have installed the
latest PostgreSQL binary distribution (8.2.5-1). Everything loaded
fine, I have postgres up and running as a service, installed ActiveTcl
and ActivePerl, enabled PostGIS, etc. I can do the CREATE LANGUAGE
'pgtcl' successfully, but I get the following error when I try to
CREATE LANGUAGE 'plperl'ERROR: could not load library "C:/Program Files
(x86)/PostgreSQL/8.2/lib/plperl.dll": %1 is not a valid Win32 application.Has anyone encountered this error with the binary install in question,
or has anyone attempted on XP Pro 64 bit? If this is a 32 vs 64 bit
issue, our plan is to eventually run on a 32 bit version, but 64 bit
is all I currently have access to.
It's almost certainly a 32 vs 64 bit issue. Do you have the 32bit or
64bit perl installed?
We have not got support for 64-bit binaries on Windows yet.
cheers
andrew
Hi Andrew,
The ActivePerl is 64 bit. Funny how it didn't affect the ActiveTcl and
pltcl load. Everything else seems to work fine, just loading the perl
lib.
Doug
On Fri, 2007-11-09 at 15:35 -0500, Andrew Dunstan wrote:
Show quoted text
Doug Knight wrote:
All,
I am building an XP Pro 64 bit system, where I have installed the
latest PostgreSQL binary distribution (8.2.5-1). Everything loaded
fine, I have postgres up and running as a service, installed ActiveTcl
and ActivePerl, enabled PostGIS, etc. I can do the CREATE LANGUAGE
'pgtcl' successfully, but I get the following error when I try to
CREATE LANGUAGE 'plperl'ERROR: could not load library "C:/Program Files
(x86)/PostgreSQL/8.2/lib/plperl.dll": %1 is not a valid Win32 application.Has anyone encountered this error with the binary install in question,
or has anyone attempted on XP Pro 64 bit? If this is a 32 vs 64 bit
issue, our plan is to eventually run on a 32 bit version, but 64 bit
is all I currently have access to.It's almost certainly a 32 vs 64 bit issue. Do you have the 32bit or
64bit perl installed?We have not got support for 64-bit binaries on Windows yet.
cheers
andrew
Doug Knight wrote:
Doug
On Fri, 2007-11-09 at 15:35 -0500, Andrew Dunstan wrote:Doug Knight wrote:
All,
I am building an XP Pro 64 bit system, where I have installed the
latest PostgreSQL binary distribution (8.2.5-1). Everything loaded
fine, I have postgres up and running as a service, installed ActiveTcl
and ActivePerl, enabled PostGIS, etc. I can do the CREATE LANGUAGE
'pgtcl' successfully, but I get the following error when I try to
CREATE LANGUAGE 'plperl'ERROR: could not load library "C:/Program Files
(x86)/PostgreSQL/8.2/lib/plperl.dll": %1 is not a valid Win32 application.Has anyone encountered this error with the binary install in question,
or has anyone attempted on XP Pro 64 bit? If this is a 32 vs 64 bit
issue, our plan is to eventually run on a 32 bit version, but 64 bit
is all I currently have access to.It's almost certainly a 32 vs 64 bit issue. Do you have the 32bit or
64bit perl installed?We have not got support for 64-bit binaries on Windows yet.
Hi Andrew,
The ActivePerl is 64 bit. Funny how it didn't affect the ActiveTcl and
pltcl load. Everything else seems to work fine, just loading the perl lib.
That's your problem right there. ActiveTcl isn't available 64-bit last I
checked, that's why that one works.
32-bit binaries work just fine on xp x64, but you need 32-bit perl.
//Magnus