Question
Deutsche Telekom Services Europe SE (DTSE)
DE
Last activity: 3 Apr 2020 11:31 EDT
Pega 8.3 on PostgreSQL 11 - PL/Java
Hi.
I try to install Pega 8.3 on a PostgreSQL 11 database. In the installation guide the PL/Java instructions are only described for PostgreSQL 9.x versions. Also the install.sql file and pljava.dll file is missing in the ResourceKit\PLJava\* folder.
As the sqlj schema is needed during the platform installation, how is the procedure to create the schema with the necessary content to run the platform installation without errors?
Thanks & regards, Matthias
***Edited by Moderator: Pallavi to change content type from Discussion to Question***
Pegasystems Inc.
US
Hi,
There is has been an update to PostgreSQL 11 to just have pljava.jar file without needing pljava.dll file. Somehow 11.x folder is missing in the ResourceKit\PLJava\ for 8.3 though PostgresSQL 11 is supported.
I would suggest you to download other available distributions like 8.3.2 & 8.4 which includes the 11.5 folders for Windows/Linux for updated pljava.jar file.
Also, the installation of UDF's are only recommended for Dev environments.
P.S:- Still there is no mention of missing documentation for 11.5 PostgreSQL which only requires 1 file on the installation guide.
Let me know if that clarifies.