From: lucas at mcsnw.com (Lucas Madar)
Date: Mon, 10 Sep 2007 08:30:02 -0700
Subject: [Pljava-dev] Installing under freebsd
Message-ID: <46E562FA.10708@mcsnw.com>

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