[Pljava-dev] Installing under freebsd

Lists: PostgreSQL : PostgreSQL 메일 링리스트 : 2007-09-10 이후 토토 캔Dev 15:30
From: lucas at mcsnw(dot)com (Lucas Madar)
To:
Subject: [Pljava-dev] Installing under freebsd
Date: 2007-09-10 15:30:02
Message-ID: 46E562FA.10708@mcsnw.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: PostgreSQL : PostgreSQL 메일 링리스트 : 2007-09-10 이후 토토 캔Dev 15:30

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