From bikle101@gmail.com Mon Jul 6 07:54:06 2026 MIME-Version: 1.0 From: Dan Bikle Date: Wed, 27 Jul 2016 12:55:45 -0700 Message-ID: Subject: [Pljava-dev] PL/Java on postgres 9.1 Content-Type: multipart/mixed; boundary="===============5642760099059594164==" --===============5642760099059594164== Content-Type: multipart/alternative; boundary=94eb2c070e1a398f6e0538a367a3 --94eb2c070e1a398f6e0538a367a3 Content-Type: text/plain; charset=UTF-8 Hello List, I want to install PL/Java on my postgres 9.1 instance. I am following instructions I see here: https://tada.github.io/pljava/install/install.html The above instructions work well for postgres 9.5, 9.3. On 9.1 I see this: [INFO] ------------------------------------------------------------------------ [INFO] Reactor Summary: [INFO] [INFO] PostgreSQL PL/Java ................................. SUCCESS [ 15.191 s] [INFO] PL/Java API ........................................ SUCCESS [ 7.572 s] [INFO] PL/Java backend Java code .......................... SUCCESS [ 3.088 s] [INFO] PL/Java backend native code ........................ SUCCESS [ 15.155 s] [INFO] PL/Java Deploy ..................................... SUCCESS [ 2.086 s] [INFO] PL/Java Ant tasks .................................. SUCCESS [ 2.365 s] [INFO] PL/Java examples ................................... SUCCESS [ 0.335 s] [INFO] PL/Java packaging .................................. SUCCESS [ 1.218 s] [INFO] ------------------------------------------------------------------------ [INFO] BUILD SUCCESS [INFO] ------------------------------------------------------------------------ [INFO] Total time: 55.829 s [INFO] Finished at: 2016-07-27T15:33:42-04:00 [INFO] Final Memory: 45M/325M [INFO] ------------------------------------------------------------------------ /usr/pgsql-9.1/lib/libpljava-so-1.5.0.so as bytes /usr/pgsql-9.1/share/pljava/pljava-1.5.0.jar as bytes /usr/pgsql-9.1/share/pljava/pljava-api-1.5.0.jar as bytes /usr/pgsql-9.1/share/pljava/pljava-examples-1.5.0.jar as bytes /usr/pgsql-9.1/share/extension/pljava.control as lines (ASCII) /usr/pgsql-9.1/share/pljava/pljava--1.5.0.sql as lines (UTF8) /usr/pgsql-9.1/share/pljava/pljava--unpackaged--1.5.0.sql as lines (UTF8) /usr/pgsql-9.1/share/pljava/pljava--1.5.0-BETA3--1.5.0.sql as lines (UTF8) /usr/pgsql-9.1/share/pljava/pljava--1.5.0-BETA2--1.5.0.sql as lines (UTF8) /usr/pgsql-9.1/share/pljava/pljava--1.5.0-BETA1--1.5.0.sql as lines (UTF8) -- -- pg_admin/set_pljava.sql -- -- This script should CREATE EXTENSION pljava SET pljava.libjvm_location TO '/opt/jdk1.8.0_92/jre/lib/amd64/server/libjvm.so'; psql:/tmp/set_pljava.sql:8: ERROR: unrecognized configuration parameter "pljava.libjvm_location" 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. LOAD \dx List of installed extensions Name | Version | Schema | Description ---------+---------+------------+------------------------------ plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language (1 row) 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'; ? -Dan Bikle --94eb2c070e1a398f6e0538a367a3 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello List,

I want to i= nstall PL/Java on my postgres 9.1 instance.

I am following instructi= ons I see here:

https://tada.github.io/pljava/install/install.html

Th= e above instructions work well for postgres 9.5, 9.3.

On 9.1 I see t= his:

[INFO] --------------------------------------------------------= ----------------
[INFO] Reactor Summary:
[INFO]
[INFO] PostgreSQL= PL/Java ................................. SUCCESS [ 15.191 s]
[INFO] PL= /Java API ........................................ SUCCESS [=C2=A0 7.572 s]=
[INFO] PL/Java backend Java code .......................... SUCCESS [= =C2=A0 3.088 s]
[INFO] PL/Java backend native code .....................= ... SUCCESS [ 15.155 s]
[INFO] PL/Java Deploy ..........................= ........... SUCCESS [=C2=A0 2.086 s]
[INFO] PL/Java Ant tasks ..........= ........................ SUCCESS [=C2=A0 2.365 s]
[INFO] PL/Java example= s ................................... SUCCESS [=C2=A0 0.335 s]
[INFO] PL= /Java packaging .................................. SUCCESS [=C2=A0 1.218 s]=
[INFO] ----------------------------------------------------------------= --------
[INFO] BUILD SUCCESS
[INFO] --------------------------------= ----------------------------------------
[INFO] Total time: 55.829 s
= [INFO] Finished at: 2016-07-27T15:33:42-04:00
[INFO] Final Memory: 45M/3= 25M
[INFO] -------------------------------------------------------------= -----------
/usr/pgsql-9.1/lib/= libpljava-so-1.5.0.so as bytes
/usr/pgsql-9.1/share/pljava/pljava-1.= 5.0.jar as bytes
/usr/pgsql-9.1/share/pljava/pljava-api-1.5.0.jar as byt= es
/usr/pgsql-9.1/share/pljava/pljava-examples-1.5.0.jar as bytes
/us= r/pgsql-9.1/share/extension/pljava.control as lines (ASCII)
/usr/pgsql-9= .1/share/pljava/pljava--1.5.0.sql as lines (UTF8)
/usr/pgsql-9.1/share/p= ljava/pljava--unpackaged--1.5.0.sql as lines (UTF8)
/usr/pgsql-9.1/share= /pljava/pljava--1.5.0-BETA3--1.5.0.sql as lines (UTF8)
/usr/pgsql-9.1/sh= are/pljava/pljava--1.5.0-BETA2--1.5.0.sql as lines (UTF8)
/usr/pgsql-9.1= /share/pljava/pljava--1.5.0-BETA1--1.5.0.sql as lines (UTF8)
--
-- pg= _admin/set_pljava.sql
--
-- This script should CREATE EXTENSION pljav= a

SET pljava.libjvm_location TO '/opt/jdk1.8.0_92/jre/lib/amd64/= server/libjvm.so';
psql:/tmp/set_pljava.sql:8: ERROR:=C2=A0 unrecogn= ized configuration parameter "pljava.libjvm_location"
LOAD = 9;libpljava-so-1.5.0.so';<= br>psql:/tmp/set_pljava.sql:9: WARNING:=C2=A0 Java virtual machine not yet = loaded
DETAIL:=C2=A0 Pausing because "pljava.enable" is set &q= uot;off".
HINT:=C2=A0 After changing any other settings as necessa= ry, set it "on" to proceed.
LOAD
\dx
=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 List of installed extensions
=C2=A0 Name=C2=A0=C2=A0 | Version |=C2= =A0=C2=A0 Schema=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 Description=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
-= --------+---------+------------+------------------------------
=C2=A0plp= gsql | 1.0=C2=A0=C2=A0=C2=A0=C2=A0 | pg_catalog | PL/pgSQL procedural langu= age
(1 row)

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';

?

-Dan Bikle


--94eb2c070e1a398f6e0538a367a3-- --===============5642760099059594164== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Pljava-dev mailing list Pljava-dev@lists.pgfoundry.org http://lists.pgfoundry.org/mailman/listinfo/pljava-dev --===============5642760099059594164==-- From chap@anastigmatix.net Mon Jul 6 07:54:06 2026 References: From: Chapman Flack Message-ID: <51b53735-82ee-1ea7-dc4f-47746b368d29@anastigmatix.net> Date: Wed, 27 Jul 2016 16:07:18 -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: > Q: How to tell postgres 9.1 that I want this: > SET pljava.libjvm_location TO > ... Hi, Those instructions are here: http://tada.github.io/pljava/install/prepg92.html Cheers, -Chap _______________________________________________ Pljava-dev mailing list Pljava-dev@lists.pgfoundry.org http://lists.pgfoundry.org/mailman/listinfo/pljava-dev From chap@anastigmatix.net Mon Jul 6 07:54:06 2026 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