[Pljava-dev] Installing under freebsd

[Lucas Madar]

Hi all,

I'm trying to install PL/Java under FreeBSD (6.1-STABLE). postgres is 
installed from ports with no modifications. I'm running into a roadblock 
with some shared libraries. I get this error message when I try to 
install into the db.

ERROR:  could not load library "/usr/local/lib/postgresql/pljava.so": 
dlopen (/usr/local/lib/postgresql/pljava.so) failed: 
/usr/local/diablo-jdk1.5.0/jre/lib/i386/server/libjvm.so: Undefined 
symbol "pthread_create"

I have the following environment variables set for the pgsql user:
JAVA_HOME=/usr/local/diablo-jdk1.5.0
LD_LIBRARY_PATH=$JAVA_HOME/jre/lib/i386:$JAVA_HOME/jre/lib/i386/native_threads:$JAVA_HOME/jre/lib/i386/server

I've found references (for Linux) that solve this problem with the 
addition of the "native_threads" bit to the pathname above, but that 
doesn't appear to change anything here.

Has anyone had success getting PL/Java to run under FreeBSD?

Thanks,
Lucas