Pgo Upgrade documentation

[Martin-Hogge]

Hi, I'm here because I feel like there is a lack of documentation about how we are supposed to upgrade PGO.

I actually run CrunchyData on kubernetes with the following docker image versions:

• postgres-operator at version ubi8-5.1.0-0
• pgo-upgrade at version ubi8-5.1.0-0 (not sure what is the purpose of this one)
• postgres database at version centos8-13.4-1
• exporter at version ubi8-5.0.3-0
• pgbackrest at version ubi8-2.38-0

I used kustomize to install CrunchyData and to apply changes to my cluster.

My main issue is that I want to upgrade to the latest 5.2.0 version but I don't know by what to begin with. What is the best way to do an upgrade ?

• Should I make a fork of postgres-example and "simply" apply changes ?
• Should I update the postgres database's image before upgrading PGO ? Or maybe after ? Or maybe not at all ?
• Same for exporter and pgbackrest, should I manually upgrade the images ?
• In my case I see that my database version is centos... while other images are ubi8..., should I switch to ubi8 ? If yes , how and what is the impact of not doing it?

One last question, does an upgrade means downtime ? Should I stop my services while executing the upgrade ?

Thank you.