From: books at ejurka.com (Kris Jurka) Date: Fri, 31 Aug 2007 14:45:16 -0400 (EDT) Subject: [Pljava-dev] Building from source for PG 8.2.4 In-Reply-To: <46D79E76.1020005@goldencode.com> References: <46D79E76.1020005@goldencode.com> Message-ID: 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//environment, > as in: Have you restarted the postgres server? These changes won't take effect without that. Kris Jurka