[SOLVED] Problem with postgresql 8.4 on debian plperl not working

matrix69 · 06-19-2012, 04:09 AM

Hello everybody. I switched to linux to build a new application and I want to use plperl with postgresql. But here's what I get after typing 'create language plperl' on postgresql command line:

could not load library "opt/PostgreSQL/8.4/lib/postgresql/plperl.so": libperl.so: cannot open shared object file: No such file or directory.

I tried to install libperl-dev, but still get the same message.

Many thanks in advance

skipper123 · 06-20-2012, 12:50 PM

Check out for a quick fix
http://raghavt.blogspot.co.uk/2011/0...d-library.html

matrix69 · 06-28-2012, 05:34 AM

thank you skipper. Actually I solved it in a much easier way. After installing postgresql 8.4 from apt I then installed the debian packages for that version for plperl, tcl and python. Everything runs fine. I could use the "create language" statement to add perl,tcl and python to a database. What is explained in the link you suggested is probably for recent versions of postgresql.