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

All,<br /> 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,
enabledPostGIS, etc. I can do the CREATE LANGUAGE 'pgtcl' successfully, but I get the following error when I try to
CREATELANGUAGE 'plperl'<br /><br /> ERROR: could not load library "C:/Program Files
(x86)/PostgreSQL/8.2/lib/plperl.dll":%1 is not a valid Win32 application.<br /><br /> Has anyone encountered this error
withthe binary install in question, or has anyone attempted on XP Pro 64 bit? If this is a 32 vs 64 bit issue, our plan
isto eventually run on a 32 bit version, but 64 bit is all I currently have access to.<br /><br /> Thanks,<br /> Doug
Knight<br/> WSI Corp<br /> Andover, MA, USA<br /><br /> 

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,<br /> The ActivePerl is 64 bit. Funny how it didn't affect the ActiveTcl and pltcl load. Everything else
seemsto work fine, just loading the perl lib.<br /><br /> Doug<br /> On Fri, 2007-11-09 at 15:35 -0500, Andrew Dunstan
wrote:<blockquote type="CITE"><pre>
 

<font color="#000000">Doug Knight wrote:</font>
<font color="#000000">> All,</font>
<font color="#000000">> I am building an XP Pro 64 bit system, where I have installed the </font>
<font color="#000000">> latest PostgreSQL binary distribution (8.2.5-1). Everything loaded </font>
<font color="#000000">> fine, I have postgres up and running as a service, installed ActiveTcl </font>
<font color="#000000">> and ActivePerl, enabled PostGIS, etc. I can do the CREATE LANGUAGE </font>
<font color="#000000">> 'pgtcl' successfully, but I get the following error when I try to </font>
<font color="#000000">> CREATE LANGUAGE 'plperl'</font>
<font color="#000000">></font>
<font color="#000000">> ERROR: could not load library "C:/Program Files </font>
<font color="#000000">> (x86)/PostgreSQL/8.2/lib/plperl.dll": %1 is not a valid Win32 application.</font>
<font color="#000000">></font>
<font color="#000000">> Has anyone encountered this error with the binary install in question, </font>
<font color="#000000">> or has anyone attempted on XP Pro 64 bit? If this is a 32 vs 64 bit </font>
<font color="#000000">> issue, our plan is to eventually run on a 32 bit version, but 64 bit </font>
<font color="#000000">> is all I currently have access to.</font>
<font color="#000000">></font>
<font color="#000000">></font>

<font color="#000000">It's almost certainly a 32 vs 64 bit issue. Do you have the 32bit or </font>
<font color="#000000">64bit perl installed?</font>

<font color="#000000">We have not got support for 64-bit binaries on Windows yet.</font>

<font color="#000000">cheers</font>

<font color="#000000">andrew</font>

</pre></blockquote>

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