Issues upgrading to a supported PostgreSQL on Jira server

David Bowerman September 7, 2022

We have an issue where we are on a unsupported version of PostgreSQL and wanted to upgrade to a supported version.  We were attempting to use the pg_upgrade method to update to PostgreSQL 12.9.1 from PostgreSQL 9.6 and managed to generate a collection of error messages not to mention getting very familiar with creating and reverting to snapshots.

Has anyone had success with that upgrade method and do you have any suggestions about a successful upgrade?

 

1 answer

0 votes
Andrew Laden
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 9, 2022

Just a suggestion, you may want to go through intermediate steps. One major version at a time. 9 to 10, 10 to 11, 11 to 12.

Suggest an answer

Log in or Sign up to answer