action #76924
Updated by ilausuch about 3 years ago
## Motivation All our CI tests run against postgres12, see https://build.opensuse.org/package/live_build_log/devel:openQA:ci/base/containers/x86_64 , as the *default* postgres version within openSUSE:Leap:15.2 is postgres12 . We should use the same version for our production instances to reduce the risk of diff between production and testing environments and also to run a version that will be supported for longer ## Acceptance criteria * **AC1:** o3 runs openQA from the current default postgres a postgres12 database version * **AC2:** no severe functional or performance related impact has been observed ## Suggestions * Research how postgres database upgrades are conducted, e.g. see #43976#note-6 * Try it out in a test environment, e.g. container loading o3 database dump file * Do it in real environment * Monitor for functional and performance impact * Check the latest stable version of postgres (currently is version 10). ## Further details https://build.opensuse.org/package/view_file/openSUSE:Leap:15.2:Update/postgresql/postgresql.spec?expand=1 shows that the default switched to 12 whereas in https://build.opensuse.org/package/view_file/openSUSE:Leap:15.1:Update/postgresql/postgresql.spec?expand=1 it looks a bit inconsistent, mixed 10+12. However all versions up from 9.6 are still supported in openSUSE Leap 15.1 and 15.2