Upgrade Postgresql from 11 to 13.13 issue
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.
Accepted Solution
Updated: 4 Jan 2024 12:58 EST
Pegasystems Inc.
US
@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.
Pegasystems Inc.
IN
Verify if the pljava files are present in the lib directory , if not add the file and check it.
Thank you
Accepted Solution
Updated: 4 Jan 2024 12:58 EST
Pegasystems Inc.
US
@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.