Postgres upgrade

New postgres image version is available on docker registry with tag 12-debezium - https://hub.docker.com/r/openlmis/postgres/tags

Upgrade instructions for each version can be found on postgres page 18.6. Upgrading a PostgreSQL Cluster

In order to properly upgrade database additional steps might be required, depending on the deployed instance:

• postgis extension upgrade (compatbility matrix: https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS )

  • generic upgrade instructions are here https://postgis.net/workshops/postgis-intro/upgrades.html

  • aws rds specific https://aws.amazon.com/blogs/database/best-practices-for-upgrading-amazon-rds-to-major-and-minor-versions-of-postgresql/

• review of custom jasper reports (might contain custom sql which is not compatible)

• review of CI/CD tools as they might use docker version incompatible with new openlmis postgres image

It is recommended to make full backup before any upgrade to prevent data loss.

After upgrade in every service, make sure that the demo-data builds successfully with new images (versions of services should be changed in ref-distro). If not, you should also:

1. Upgrade postgres for demo-data

2. Upgrade postgres for base service and then change it for every service