plperl won't load on Win2k3

[Raymond Auge]

Hello All,

I'd like to know what I am doing wrong. I've installed the 7.5 win32 version of Postgres (love it...). I've entered the bin directory and loaded the plpgsql language on my database (works fine)...

I have perl 5.6.1 installed as well and would like to load the plperl language on the db as well.

While in the %postgresql%\bin I try

createlang plperl dbname

createlang: language installation failed: ERROR: could not load library "C:/Pro
gram Files/PostgreSQL/7.5/lib/plperl.dll": error

The plperl.dll _IS_ there.

I've added the perl interpreted to the path, but thought that maybe I also need the perl libs on a lib path.

Can anyone say if this is correct and what how to set that value?



--------------------------------------------------------------
Raymond Augé, B.COSC
Spécialiste en médiatisation de la formation/Multimedia specialist
Université Laurentienne / Laurentian University
<***@laurentienne.ca> / <***@laurentian.ca>
[phone] x3934



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Magnus Hagander]

Post by Raymond Auge
Hello All,
I'd like to know what I am doing wrong. I've installed the
7.5 win32 version of Postgres (love it...). I've entered the
bin directory and loaded the plpgsql language on my database
(works fine)...
I have perl 5.6.1 installed as well and would like to load
the plperl language on the db as well.
While in the %postgresql%\bin I try

createlang plperl dbname

createlang: language installation failed: ERROR: could not
load library "C:/Pro gram Files/PostgreSQL/7.5/lib/plperl.dll": error
The plperl.dll _IS_ there.
I've added the perl interpreted to the path, but thought that
maybe I also need the perl libs on a lib path.
Can anyone say if this is correct and what how to set that value?

Hello!

Are you installing from the MSI installer? If so, you need ActiveState
Perl 5.8 for plperl to work - it will not work with 5.6, and it will
(probably) not work with other perl distributions.

If this is not the problem, use "depends.exe" from the support tools on
the plperl.dll and see if there is a broken DLL dependency somewhere.

Also, you shuold really upgrade to the latest beta. (It hasn't been
called 7.5 for quite a while).

//Magnus


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly