{"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;&nbsp;<\/p>\n","protected":false},"author":28,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133],"tags":[],"class_list":["post-7430","post","type-post","status-publish","format-standard","category-database"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Install PL\/JAVA in PostgreSQL 9.5.1 - dbi services 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;&nbsp;\" \/>\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 services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-25T16:03:34+00:00\" \/>\n<meta name=\"author\" content=\"Open source Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Open source Team\" \/>\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\":\"Open source Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\"},\"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,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"articleSection\":[\"Database\"],\"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 services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2016-03-25T16:03:34+00:00\",\"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\":\"Home\",\"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 services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"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\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0b4548362cac3eeff8b3eaf329e3530a\",\"name\":\"Open source Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/open-source-author.png\",\"caption\":\"Open source Team\"},\"description\":\"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/open-source-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Install PL\/JAVA in PostgreSQL 9.5.1 - dbi services 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;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/install-pljava-in-postgresql-9-5-1\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2016-03-25T16:03:34+00:00","author":"Open source Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Open source Team","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":"Open source Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a"},"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,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"articleSection":["Database"],"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 services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2016-03-25T16:03:34+00:00","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":"Home","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 services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"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":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0b4548362cac3eeff8b3eaf329e3530a","name":"Open source Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/05\/open-source-author.png","caption":"Open source Team"},"description":"Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.","url":"https:\/\/www.dbi-services.com\/blog\/author\/open-source-team\/"}]}},"_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\/28"}],"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"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}