Project

General

Profile

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

Back