From: rakesh at rakeshv.org (Rakesh Vidyadharan)
Date: Thu, 27 Oct 2005 06:31:07 -0500
Subject: [Pljava-dev] PostgreSQL is unable to load the libpljava.so
In-Reply-To: <loom.20051027T084439-37@post.gmane.org>
References: <loom.20051027T084439-37@post.gmane.org>
Message-ID: <ECCE02FF-8422-416F-9746-7D5FB3A33429@rakeshv.org>


On 27 Oct 2005, at 01:55, Nacho wrote:

> Hello
> I?m trying to install PLJAVA in PostgreSQL 8.0 (Red hat 9) but I can 
> ?t install
> because I get an error loading libpljava.so.
> I have defined the JAVA_HOME, the PATH, the LD_LIBRARY_PATH and  
> CLASSPATH
> environment variables but I get the error
>
> java.sql.SQLException :ERROR: could not load
> library "/var/lib/pgsql/pljava/libpljava.so": libjvm.so: cannot  
> open shared
> object file: No such file or directory
>
> JAVA_HOME=/usr/java/jre1.5.0_01
> PATH=$PATH:.:$JAVA_HOME/lib/i386/server:$JAVA_HOME/bin
> LD_LIBRARY_PATH=$JAVA_HOME/lib/i386:$JAVA_HOME/lib/i386/client: 
> $JAVA_HOME/lib/i3
> 86/native_threads

Do you have something similar to the following in your  
postgresql.conf file?

dynamic_library_path = '$libdir:/usr/local/pgsql/lib/pljava'