[Pljava-dev] can't find libjvm

"Welty, Richard" <rwelty at ltionline.com> writes:

> i'm trying a first time install on an amazon ec2 linux instance
> (amazon linux, which is centos based), open jdk 1.6.
>
> i'm using this distribution tar file from pgfoundry:
> pljava-x86_64-unknown-linux-gnu-pg9.1-1.4.3.tar.gz

For 1.4.3 you can use any JRE 1.4 and up. Both the Sun (now Oracle) JRE
or IBM Java or another Java certified implementation.

> the instructions need some work, but i've hacked my way through to
> this point, trying to run deploy. i'm currently stalled at the
> following:
>
> # java -cp /usr/share/java/postgresql-jdbc.jar:/opt/pljava/deploy.jar
> org.postgresql.pljava.deploy.Deployer -install -user postgres
> -database gf org.postgresql.util.PSQLException: ERROR: could not load
> library "/opt/pljava/ pljava.so": libjvm.so: cannot open shared object
> file: No such file or directory

libjvm.so is part of the JRE. If it's missing from your system it
appears the relevant package is missing. I suspect this is a dependency
bug in the PL/Java pakcage.

You need to install the relevant JRE package on your system, or download
a tarball/package from Oracle, IBM or somebody else.

> i'm not finding libjvm.so anywhere on the system; perhaps the
> prepackaged jar was built for a different jvm.

It does not matter which JDK was used to compile PL/Java, only that the
postgres server process can find libjvm.so. Sometimes the search path
is built into pljava.so, other times it's system configured and
sometimes you need to set LD_LIBRARY_PATH.

--
Johann Oskarsson http://www.2ndquadrant.com/ |[]
PostgreSQL Development, 24x7 Support, Training and Services --+--
|
Blog: http://my.opera.com/myrkraverk/blog/