Skip to content

Prebuilt packages

Chapman Flack edited this page Sep 19, 2023 · 10 revisions

Prebuilt PL/Java distributions

At present, the PL/Java project is reliant on downstream packagers to produce prebuilt, installable PL/Java packages for various platforms. The official PL/Java releases are offered in source form and take only a few minutes to build with Apache Maven as described in the build instructions.

This wiki page will be updated to list known prebuilt PL/Java packages and the platforms they are built for. As with any prebuilt distribution, you should be acquainted with the policies and reputation of any supplier of a prebuilt package. The PL/Java project has not directly built or verified any package listed here.

Known prebuilt packages available

Debian/Ubuntu packages on apt.postgresql.org

As of 2020, the Debian/Ubuntu packages have been consistently available at the current PL/Java versions (now 1.5.6) and for a range of Debian, Ubuntu, and PostgreSQL versions and architectures.

{1.5.2,"11.1 (Debian 11.1-1.pgdg+1)",11.0.1,Linux,amd64}

PL/Java 1.5.2 packages available for PostgreSQL 11 back to 9.3 for Debian unstable/buster/stretch and Ubuntu cosmic/bionic/xenial, for amd64/i386/ppc64el. Dbgsym packages available. Includes pljava-examples jar with the optional Saxon examples already built (download Saxon-HE 9.8.0.14 jar separately to use them).

Added 14 November 2018 Updated 5 October 2020

Docker images

Bear Giles reports offering the following images on hub.docker.com:

From information 9 August 2023

Adrian Escutia Soto has prepared an image of 64-bit PostgreSQL 11 on Debian with Java 11 and PL/Java 1.6.2 for use with Docker.

{1.6.2,"11.11 (Debian 11.11-1.pgdg90+1)",11.0.6,Linux,amd64}

added 21 February 2021

Martin Bednar has prepared images of 64-bit PostgreSQL (9.5 and 9.4) with PL/Java 1.5.0 and Oracle Java 8 for use with Docker.

{1.5.0,9.5.1,1.8.0_74,Linux,amd64}
{1.5.0,9.4.6,1.8.0_74,Linux,amd64}

added 12 April 2016

Complete PostgreSQL distributions from BigSQL

BigSQL provides native installers for Centos 6 and 7, Ubuntu 12.04 and 14.04, OS X 10.9+, Windows 7+, and Windows Server 2008 and 2012. These distributions of PostgreSQL 9.5, 9.4, 9.3, and 9.2 include PL/Java 1.5.0.

added 12 April 2016

To list a prebuilt package here

Please announce the availability of your package on the pljava-dev mailing list, along with the output of the third query below:

Note: as of mid-May 2016, the pljava-dev mailing list is working again, and should be used to announce packages. In case the mailing list does not seem to work, then please open an issue.

SELECT sqlj.install_jar( fileurl-to-built-pljava-examples-*.jar , 'ex', true);
SELECT sqlj.set_classpath('javatest', 'ex');

SELECT array_agg(java_getsystemproperty(p)) FROM (values
('org.postgresql.pljava.version'),
('org.postgresql.version'),
('java.version'),
('os.name'),
('os.arch')
) AS props(p);