Re: plperl.dll error from create langauge plperl (XP Pro 64 bit)

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Doug Knight <dknight(at)wsi(dot)com>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: plperl.dll error from create langauge plperl (XP Pro 64 bit)
Date: 2007-11-09 21:16:14
Message-ID: 4734CE1E.2050101@hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2007-11-09 21:28:39 dump order for index defs
Previous Message Pavel Stehule 2007-11-09 21:13:30 last note to rewrite function