Upgrade Postgresql from 11 to 13.13 issue

General
, , , ,
1

Hi Team,

We are trying to upgrade Postgresql from 11 to 13.13 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>

Can you help Please.

2

@issamr22

Verify if the pljava files are present in the lib directory , if not add the file and check it.

Thank you

3

@issamr22 Different approach: for upgrades we create a new DB server first.

Orig DB server: full DB backup, next drop sqlj schema from DB, and then another full DB backup. Restore this 2nd backup at new DB server (the backup without the sqlj schema) and once it’s all good there, add pljava to new DB server.