[Pljava-dev] Building from source for PG 8.2.4

[Kris Jurka]

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