Postgresql upgrade to version 14

[Bruce Eckstein]

I recently upgraded Ubuntu server 20.04 to 22.04. In the upgrade process, it said I needed to upgrade the postgres clusters to version 14 from version 12 as 12 is no longer supported. Is there anything I need to do to the Bareos before doing this cluster upgrade?

PS I do not understand what the cluster version upgrade implication is on existing databases within the postgres system!

[Bruce Eckstein]

also this is on a single server (i.e. it is NOT high availability setup) if that makes any difference.

[Aaron Were]

Is this likely to be an issue? The database itself shouldn't have modified the schema/data/interfaces very much at all, for the most part BareOS is as "any other" database consuming application.. or so I thought anyway. But if you've misgivings, then maybe there's something I'm missing?

https://www.postgresql.org/docs/14/release.html (there are already many versions of 14 to compare the  changes too). Quite a list of changes, I don't have deep knowledge of the requirements of BareOS's database consumption to know if any of these will have negative effects.

I wouldn't want to steer you wrong.  

https://docs.bareos.org/master/IntroductionAndTutorial/UpdatingBareos.html

https://docs.bareos.org/master/TasksAndConcepts/CatalogMaintenance.html#postgresql-database

[Bruce Eckstein]

Upgrade went without a hitch. Thank you for the response