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 https://www.postgresql.org/docs/current/upgrading.html
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:
Upgrade postgres for base service and then change it for every service
OpenLMIS: the global initiative for powerful LMIS software