[Pljava-dev] Building from source for PG 8.2.4

On Fri, 31 Aug 2007, Eric Faulhaber wrote:

> Curiously, I ended up with a pljava.so that was nearly 5 times larger
> than the version which was distributed with the PL/Java 1.3.0 release.
> Any idea why this would be? Does the default build included debug
> symbols?
>

It will pick up the compile options used for the server it's built
against (see pg_config --cflags). I'm not sure how the release was made,
but you can certainly check your own config.

> Anyway, when I try to deploy to a database using install.sql, it
> complains that it is unable to locate the JVM:
>
> psql:install.sql:6: ERROR: could not load library
> "/usr/lib/postgresql/8.2/lib/pljava.so":
> /usr/lib/postgresql/8.2/lib/pljava.so: undefined symbol: JNI_CreateJavaVM
>
> I've made all the same changes to postgresql.conf that were necessary to
> get this to work with my previous PG 8.1.8 installation. Likewise, I
> have set LD_LIBRARY_PATH in exactly the same way as was working before.
> For Kubuntu, this is set in /etc/postgresql/8.2/<mycluster>/environment,
> as in:

Have you restarted the postgres server? These changes won't take effect
without that.

Kris Jurka