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==--