{"id":7430,"date":"2016-03-25T17:03:34","date_gmt":"2016-03-25T16:03:34","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/"},"modified":"2016-03-25T17:03:34","modified_gmt":"2016-03-25T16:03:34","slug":"install-pljava-in-postgresql-9-5-1","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/","title":{"rendered":"Install PL\/JAVA in PostgreSQL 9.5.1"},"content":{"rendered":"<p>Some time ago I <a href=\"http:\/\/dbi-services.com\/blog\/install-pljava-in-postgres-plus-advanced-server-9-5\/\" target=\"_blank\" rel=\"noopener\">blogged<\/a> about how to install <a href=\"https:\/\/github.com\/tada\/pljava\/wiki\" target=\"_blank\" rel=\"noopener\">PL\/JAVA<\/a> in <a href=\"http:\/\/www.enterprisedb.com\/products-services-training\/products\/postgres-plus-advanced-server\" target=\"_blank\" rel=\"noopener\">Postgres Plus Advanced Server 9.5<\/a>. This resulted in an <a href=\"http:\/\/dbi-services.com\/blog\/install-pljava-in-postgres-plus-advanced-server-9-5\/#comment-3073\" target=\"_blank\" rel=\"noopener\">interesting comment<\/a> from the maintainer of PL\/Java. After exchanging some emails and some more testing it turned out that there really is an issue with my build of PostgreSQL. I usually compile PostgreSQL from source and use the &#8220;&#8211;with-extra-version&#8221; flag when I do the &#8220;.\/configure&#8221; and that seems to be an issue (at least in 1.5.0-BETA3). So, lets try to install PL\/JAVA into a PostgreSQL 9.5.1 instance which was not compiled with the &#8220;&#8211;with-extra-version&#8221; option.<\/p>\n<p>If you take a look at the <a href=\"http:\/\/tada.github.io\/pljava\/build\/build.html\" target=\"_blank\" rel=\"noopener\">build instructions<\/a> for PL\/JAVA there are a few requirements before we can start:<\/p>\n<ul>\n<li>We need to be able to compile and link C code<\/li>\n<li>We need a java compiler <\/li>\n<li>We need <a href=\"http:\/\/www.postgresql.org\/docs\/current\/static\/app-pgconfig.html\" target=\"_blank\" rel=\"noopener\">pg_config<\/a>. This is available by default once PostgreSQL is installed.<\/li>\n<li>We need <a href=\"https:\/\/maven.apache.org\/\" target=\"_blank\" rel=\"noopener\">Maven<\/a> for building PL\/JAVA<\/li>\n<\/ul>\n<p>As I am on a RedHat based distribution installing the C and Java compiler is just a matter of using yum:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\n[root@oel7 ~]$ yum install gcc-c++ gcc java-1.8.0-openjdk-devel\n<\/pre>\n<p>Once these are installed the first two requirements are met:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\npostgres@oel7:\/home\/postgres\/ [PG11] g++ -version\ng++: error: unrecognized command line option \u2018-version\u2019\ng++: fatal error: no input files\ncompilation terminated.\npostgres@oel7:\/home\/postgres\/ [PG11] g++ --version\ng++ (GCC) 4.8.5 20150623 (Red Hat 4.8.5-4)\nCopyright (C) 2015 Free Software Foundation, Inc.\nThis is free software; see the source for copying conditions.  There is NO\nwarranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.\n\npostgres@oel7:\/home\/postgres\/ [PG11] javac -version\njavac 1.8.0_71\n<\/pre>\n<p>For pg_config I do not need to do anything as my PostgreSQL environment is already set:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\npostgres@oel7:\/home\/postgres\/ [PG11] which pg_config\n\/u01\/app\/postgres\/product\/95\/db_1\/bin\/pg_config\npostgres@oel7:\/home\/postgres\/ [PG11] pg_config\nBINDIR = \/u01\/app\/postgres\/product\/95\/db_1\/bin\nDOCDIR = \/u01\/app\/postgres\/product\/95\/db_1\/doc\/postgresql\nHTMLDIR = \/u01\/app\/postgres\/product\/95\/db_1\/doc\/postgresql\nINCLUDEDIR = \/u01\/app\/postgres\/product\/95\/db_1\/include\nPKGINCLUDEDIR = \/u01\/app\/postgres\/product\/95\/db_1\/include\/postgresql\nINCLUDEDIR-SERVER = \/u01\/app\/postgres\/product\/95\/db_1\/include\/postgresql\/server\nLIBDIR = \/u01\/app\/postgres\/product\/95\/db_1\/lib\nPKGLIBDIR = \/u01\/app\/postgres\/product\/95\/db_1\/lib\/postgresql\nLOCALEDIR = \/u01\/app\/postgres\/product\/95\/db_1\/share\/locale\nMANDIR = \/u01\/app\/postgres\/product\/95\/db_1\/share\/man\nSHAREDIR = \/u01\/app\/postgres\/product\/95\/db_1\/share\/postgresql\nSYSCONFDIR = \/u01\/app\/postgres\/product\/95\/db_1\/etc\/postgresql\nPGXS = \/u01\/app\/postgres\/product\/95\/db_1\/lib\/postgresql\/pgxs\/src\/makefiles\/pgxs.mk\nCONFIGURE = '--with-libs=\/opt\/local\/Current\/lib' '--with-includes=\/opt\/local\/Current\/include\/libxml2:\/opt\/local\/Current\/include' '--prefix=\/mnt\/hgfs\/pginstaller.auto\/server\/staging\/linux-x64' '--with-ldap' '--with-openssl' '--with-perl' '--with-python' '--with-tcl' '--with-tclconfig=\/opt\/local\/EnterpriseDB\/LanguagePack\/9.5\/Tcl-8.5\/lib' '--with-pam' '--enable-thread-safety' '--with-libxml' '--with-ossp-uuid' '--docdir=\/mnt\/hgfs\/pginstaller.auto\/server\/staging\/linux-x64\/doc\/postgresql' '--with-libxslt' '--with-libedit-preferred' '--with-gssapi' 'LD_LIBRARY_PATH=\/opt\/local\/Current\/lib' 'CFLAGS=-DMAP_HUGETLB=0x40000'\nCC = gcc\nCPPFLAGS = -D_GNU_SOURCE -I\/opt\/local\/Current\/include\/libxml2 -I\/opt\/local\/Current\/include\nCFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -DMAP_HUGETLB=0x40000\nCFLAGS_SL = -fpic\nLDFLAGS = -L..\/..\/..\/src\/common -L\/opt\/local\/Current\/lib -Wl,--as-needed -Wl,-rpath,'\/mnt\/hgfs\/pginstaller.auto\/server\/staging\/linux-x64\/lib',--enable-new-dtags\nLDFLAGS_EX = \nLDFLAGS_SL = \nLIBS = -lpgcommon -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -ledit -lrt -lcrypt -ldl -lm \nVERSION = PostgreSQL 9.5.1\n<\/pre>\n<p>The last requirement is Maven and this is trivial to install, too:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\npostgres@oel7:\/home\/postgres\/ [PG11] mkdir -p \/u01\/app\/postgres\/product\/maven\npostgres@oel7:\/home\/postgres\/ [PG11] cd \/u01\/app\/postgres\/product\/maven\npostgres@oel7:\/u01\/app\/postgres\/product\/maven\/ [PG11] wget http:\/\/mirror.easyname.ch\/apache\/maven\/maven-3\/3.3.9\/binaries\/apache-maven-3.3.9-bin.tar.gz\npostgres@oel7:\/u01\/app\/postgres\/product\/maven\/ [PG11] tar -axf apache-maven-3.3.9-bin.tar.gz \npostgres@oel7:\/u01\/app\/postgres\/product\/maven\/ [PG11] cd apache-maven-3.3.9\npostgres@oel7:\/u01\/app\/postgres\/product\/maven\/apache-maven-3.3.9\/ [PG11] bin\/mvn -version\nApache Maven 3.3.9 (bb52d8502b132ec0a5a3f4c09453c07478323dc5; 2015-11-10T17:41:47+01:00)\nMaven home: \/u01\/app\/postgres\/product\/maven\/apache-maven-3.3.9\nJava version: 1.8.0_71, vendor: Oracle Corporation\nJava home: \/usr\/lib\/jvm\/java-1.8.0-openjdk-1.8.0.71-2.b15.el7_2.x86_64\/jre\nDefault locale: en_US, platform encoding: UTF-8\nOS name: \"linux\", version: \"3.8.13-118.4.1.el7uek.x86_64\", arch: \"amd64\", family: \"unix\"\n<\/pre>\n<p>That&#8217;s it. Maven is ready and we can start with building PL\/JAVA ( <a href=\"https:\/\/github.com\/tada\/pljava\/releases\/tag\/V1_5_0b3\" target=\"_blank\" rel=\"noopener\">Release 1.5.0-BETA3<\/a> for the scope of this post ):<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\npostgres@oel7:\/u01\/app\/postgres\/product\/maven\/apache-maven-3.3.9\/ [PG11] mkdir -p \/u01\/app\/postgres\/product\/pljava\npostgres@oel7:\/u01\/app\/postgres\/product\/maven\/apache-maven-3.3.9\/ [PG11] cd \/u01\/app\/postgres\/product\/pljava\npostgres@oel7:\/u01\/app\/postgres\/product\/pljava\/ [PG11] wget https:\/\/github.com\/tada\/pljava\/archive\/V1_5_0b3.tar.gz\npostgres@oel7:\/u01\/app\/postgres\/product\/pljava\/ [PG11] tar -axf V1_5_0b3.tar.gz \npostgres@oel7:\/u01\/app\/postgres\/product\/pljava\/ [PG11] cd pljava-1_5_0b3\/\npostgres@oel7:\/u01\/app\/postgres\/product\/pljava\/pljava-1_5_0b3\/ [PG11] export PATH=\/u01\/app\/postgres\/product\/maven\/apache-maven-3.3.9\/bin\/:$PATH\npostgres@oel7:\/u01\/app\/postgres\/product\/pljava\/pljava-1_5_0b3\/ [PG11] mvn clean install\n<\/pre>\n<p>The last command produces plenty of output. The important notes are at the end:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\n[INFO] ------------------------------------------------------------------------\n[INFO] Reactor Summary:\n[INFO] \n[INFO] PostgreSQL PL\/Java ................................. SUCCESS [  6.739 s]\n[INFO] PL\/Java API ........................................ SUCCESS [  5.920 s]\n[INFO] PL\/Java backend Java code .......................... SUCCESS [  3.444 s]\n[INFO] PL\/Java backend native code ........................ SUCCESS [ 46.330 s]\n[INFO] PL\/Java Deploy ..................................... SUCCESS [  3.397 s]\n[INFO] PL\/Java Ant tasks .................................. SUCCESS [  1.346 s]\n[INFO] PL\/Java examples ................................... SUCCESS [  3.731 s]\n[INFO] PL\/Java packaging .................................. SUCCESS [  7.674 s]\n[INFO] ------------------------------------------------------------------------\n[INFO] BUILD SUCCESS\n[INFO] ------------------------------------------------------------------------\n[INFO] Total time: 01:21 min\n[INFO] Finished at: 2016-03-23T10:25:14+01:00\n[INFO] Final Memory: 38M\/93M\n[INFO] ------------------------------------------------------------------------\n<\/pre>\n<p>Looks fine so far. Following the <a href=\"http:\/\/tada.github.io\/pljava\/install\/install.html\" target=\"_blank\" rel=\"noopener\">installation instructions<\/a> to install PL\/JAVA:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\npostgres@oel7:\/u01\/app\/postgres\/product\/pljava\/pljava-1_5_0b3\/ [PG11] java -jar pljava-packaging\/target\/pljava-pg9.5-amd64-Linux-gpp.jar\n\/u01\/app\/postgres\/product\/95\/db_1\/lib\/postgresql\/libpljava-so-1.5.0-BETA3.so as bytes\n\/u01\/app\/postgres\/product\/95\/db_1\/share\/postgresql\/pljava\/pljava-1.5.0-BETA3.jar as bytes\n\/u01\/app\/postgres\/product\/95\/db_1\/share\/postgresql\/pljava\/pljava-api-1.5.0-BETA3.jar as bytes\n\/u01\/app\/postgres\/product\/95\/db_1\/share\/postgresql\/pljava\/pljava-examples-1.5.0-BETA3.jar as bytes\n\/u01\/app\/postgres\/product\/95\/db_1\/share\/postgresql\/extension\/pljava.control as lines (ASCII)\n\/u01\/app\/postgres\/product\/95\/db_1\/share\/postgresql\/pljava\/pljava--1.5.0-BETA3.sql as lines (UTF8)\n\/u01\/app\/postgres\/product\/95\/db_1\/share\/postgresql\/pljava\/pljava--unpackaged--1.5.0-BETA3.sql as lines (UTF8)\n\/u01\/app\/postgres\/product\/95\/db_1\/share\/postgresql\/pljava\/pljava--1.5.0-BETA2--1.5.0-BETA3.sql as lines (UTF8)\n\/u01\/app\/postgres\/product\/95\/db_1\/share\/postgresql\/pljava\/pljava--1.5.0-BETA1--1.5.0-BETA3.sql as lines (UTF8)\n<\/pre>\n<p>Looks fine, too. Everything needed by PostgreSQL to install the extension should be there now. Lets try:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\npostgres@oel7:\/u01\/app\/postgres\/product\/pljava\/pljava-1_5_0b3\/ [PG11] psql postgres\nNull display is \"NULL\".\nTiming is on.\npsql.bin (9.5.1)\nType \"help\" for help.\n\n(postgres@[local]:7777) [postgres] &gt; create extension pljava;\nCREATE EXTENSION\nTime: 1947.125 ms\n(postgres@[local]:7777) [postgres] &gt; dx\n                                   List of installed extensions\n  Name   |   Version   |   Schema   |                         Description                          \n---------+-------------+------------+--------------------------------------------------------------\n pljava  | 1.5.0-BETA3 | sqlj       | PL\/Java procedural language (https:\/\/tada.github.io\/pljava\/)\n plpgsql | 1.0         | pg_catalog | PL\/pgSQL procedural language\n(2 rows)\n\n<\/pre>\n<p>Ready to be used &#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Some time ago I blogged about how to install PL\/JAVA in Postgres Plus Advanced Server 9.5. This resulted in an interesting comment from the maintainer of PL\/Java. After exchanging some emails and some more testing it turned out that there really is an issue with my build of PostgreSQL. I usually compile PostgreSQL from source [&hellip;]<\/p>\n","protected":false},"author":29,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[77],"type_dbi":[],"class_list":["post-7430","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-postgresql"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Install PL\/JAVA in PostgreSQL 9.5.1 - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Install PL\/JAVA in PostgreSQL 9.5.1\" \/>\n<meta property=\"og:description\" content=\"Some time ago I blogged about how to install PL\/JAVA in Postgres Plus Advanced Server 9.5. This resulted in an interesting comment from the maintainer of PL\/Java. After exchanging some emails and some more testing it turned out that there really is an issue with my build of PostgreSQL. I usually compile PostgreSQL from source [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-25T16:03:34+00:00\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"Install PL\/JAVA in PostgreSQL 9.5.1\",\"datePublished\":\"2016-03-25T16:03:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/\"},\"wordCount\":287,\"commentCount\":0,\"keywords\":[\"PostgreSQL\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/\",\"name\":\"Install PL\/JAVA in PostgreSQL 9.5.1 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2016-03-25T16:03:34+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Install PL\/JAVA in PostgreSQL 9.5.1\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &amp;\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\/\/x.com\/westermanndanie\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Install PL\/JAVA in PostgreSQL 9.5.1 - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/","og_locale":"en_US","og_type":"article","og_title":"Install PL\/JAVA in PostgreSQL 9.5.1","og_description":"Some time ago I blogged about how to install PL\/JAVA in Postgres Plus Advanced Server 9.5. This resulted in an interesting comment from the maintainer of PL\/Java. After exchanging some emails and some more testing it turned out that there really is an issue with my build of PostgreSQL. I usually compile PostgreSQL from source [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/","og_site_name":"dbi Blog","article_published_time":"2016-03-25T16:03:34+00:00","author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"Install PL\/JAVA in PostgreSQL 9.5.1","datePublished":"2016-03-25T16:03:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/"},"wordCount":287,"commentCount":0,"keywords":["PostgreSQL"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/","url":"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/","name":"Install PL\/JAVA in PostgreSQL 9.5.1 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-03-25T16:03:34+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Install PL\/JAVA in PostgreSQL 9.5.1"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &amp;\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7430","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=7430"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7430\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7430"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=7430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}