Actions
action #164299
opencoordination #157969: [epic] Upgrade all our infrastructure, e.g. o3+osd workers+webui and production workloads, to openSUSE Leap 15.6
Upgrade postgresql database on qam.suse.de
Start date:
2024-07-22
Due date:
% Done:
0%
Estimated time:
Tags:
Description
Observation¶
rrichardson has observed that as of now qam2 is still running PostgreSQL 12 which is rather old vs. the current default of PostgreSQL 16 on Leap 15.6. We should upgrade to 16.
Acceptance criteria¶
- AC1: postgres on qam2.suse.de runs a current PostgreSQL version
- AC2: No postgres <= 15 packages installed on qam2.suse.de
- AC3: No failed services, e.g.
systemctl is-system-running
, and https://dashboard.qam.suse.de/
Suggestions¶
ssh root@qam.suse.de
andmachinectl shell postgresql
- Ensure we have a recent database backup
- Migrate PostgreSQL, similar to https://open.qa/docs/#_migrating_postgresql_database_on_opensuse
Actions