My problem seems to be due to a 32-bit vs. 64-bit issue. I found this remark in the readme the came with the precompiled pg82 binaries:

The PL/Perl and PL/Python languages have been dropped for now - they currently don't build 64bit.

This led me to this page on the Apple site:  http://developer.apple.com/releasenotes/OpenSource/PerlExtensionsRelNotes/index.html

Sounds like I need to recompile my perl5.8 installation. Unfortunately, I don't know enough about compiling for processor architectures to know what to do.

If anyone has any suggestions, I'd appreciate it.

Thanks,
Tim


On Thu, Feb 28, 2008 at 9:18 PM, Tim Holahan <tim.holahan@gmail.com> wrote:
Hi. I'm trying to install plperl along with postgres 8.2 on a MacBook running Leopard by issuing the following command:

port install postgresql82 +perl

Everything seems to go smoothly (see the output below my signature). However, after I create a database, attempts to CREATE LANGUAGE 'plperl' (and 'plperlu') fail in psql with the message:

ERROR:  could not access file "$libdir/plperl": No such file or directory

The plperl.so and libperl.so files are nowhere to be found. The perl5.8 port is installed.

I'd be grateful for any help with this.

Thanks,
Tim

-->  Fetching postgresql82
--->  Verifying checksum(s) for postgresql82
--->  Extracting postgresql82
--->  Configuring postgresql82
--->  Building postgresql82
--->  Staging postgresql82 into destroot
--->  Installing postgresql82 8.2.6_0+perl

To use the postgresql server, install the postgresql82-server port
--->  Activating postgresql82 8.2.6_0+perl