References: From: Chapman Flack Message-ID: <091771b8-7aef-2511-81b1-9c8cf180102d@anastigmatix.net> Date: Wed, 27 Jul 2016 16:42:49 -0400 MIME-Version: 1.0 In-Reply-To: Subject: Re: [Pljava-dev] PL/Java on postgres 9.1 Content-Type: text/plain; charset="us-ascii" On 07/27/2016 03:55 PM, Dan Bikle wrote: > LOAD 'libpljava-so-1.5.0.so'; > psql:/tmp/set_pljava.sql:9: WARNING: Java virtual machine not yet loaded > DETAIL: Pausing because "pljava.enable" is set "off". > HINT: After changing any other settings as necessary, set it "on" to > proceed. > Q: How to tell postgres 9.1 that I want this: > SET pljava.libjvm_location TO > '/opt/jdk1.8.0_92/jre/lib/amd64/server/libjvm.so'; Just to summarize what the http://tada.github.io/pljava/install/prepg92.html page says, after you have reached this point (LOAD paused because pljava.enable is off), you can issue that SET command and it will be recognized. You will, then, also need to SET pljava.enable TO on; to let the startup complete. Once you've determined the settings that work, in PG < 9.2 you have to edit them into postgresql.conf to make them persist. -Chap _______________________________________________ Pljava-dev mailing list Pljava-dev@lists.pgfoundry.org http://lists.pgfoundry.org/mailman/listinfo/pljava-dev