Hi Team, 

We are trying to upgrade Postgresql from 11 to 12 in one of our PEGA environments. Initially we got an error related to missing “pljava” file while running pg_upgrade command.

        could not load library "pljava": ERROR: could not access file "pljava": No such file or directory

        Database: <db_name>

We copied pljava.so and pljava.jar files from current postgres(11) user bin directory to the new postgres(12) user bin directory then reran pg_upgrade command and got below error.

        could not load library "pljava": ERROR: could not load library "/usr/pgsql-12/lib/pljava.so"

        : /usr/pgsql-       12/lib/pljava.so: undefined symbol: GetCurrentAbsoluteTime

         Database: <db_name>

Here are the environment details:

OS: CentOS Linux 7

PEGA : Pega Platform 8.6.4

Current database: Postgresql-11

Postgresql.conf in postgresql-11 for pljava

               pljava.classpath='/usr/pgsql-11/lib/pljava.jar'

pljava.vmoptions = '-Xms32M -Xmx64M -XX:ParallelGCThreads=2'

work_mem = 5MB

pljava.libjvm_location = '/lib/libjvm.so'

New database version: Postgresql-12

Postgresql.conf in postgresql-12 for pljavasys

pljava.classpath='/usr/pgsql-12/lib/pljava.jar'

pljava.vmoptions = '-Xms32M -Xmx64M -XX:ParallelGCThreads=2'

work_mem = 5MB

pljava.libjvm_location = '/lib/libjvm.so'

We  tried to find pljava files on PEGA software and I couldn’t find them for PostgreSQL-12. Could you please share these files with us. We will try running pg_upgrade again once we got new pljava files.

May be somebody already had such an issue and has an idea how to deal with this? 

Thank you!