Actions
action #164299
closedcoordination #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 size:S
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
Updated by okurz 3 months ago
- Copied from action #157987: Upgrade qam hosts maintained by us to latest stable, i.e. Leap 15.6 added
Updated by okurz about 2 months ago
- Subject changed from Upgrade postgresql database on qam.suse.de to Upgrade postgresql database on qam.suse.de size:S
- Status changed from New to Workable
Updated by jbaier_cz about 2 months ago
- Status changed from Workable to In Progress
Updated by jbaier_cz about 2 months ago
- Status changed from In Progress to Resolved
Migration done by following steps from https://open.qa/docs/#_migrating_postgresql_database_on_opensuse; additionally, changes from pg_hba.conf were also transferred over.
AC1:
postgres@postgresql:~> psql
psql (16.2)
AC2:
postgresql:~ # zypper se --installed-only postgres
S | Name | Summary | Type
---+----------------------+----------------------------------------------------+--------
i+ | postgresql | Basic Clients and Utilities for PostgreSQL | package
i+ | postgresql-contrib | Contributed Extensions and Additions to PostgreSQL | package
i+ | postgresql-server | The Programs Needed to Create and Run a PostgreS-> | package
i+ | postgresql16 | Basic Clients and Utilities for PostgreSQL | package
i+ | postgresql16-contrib | Contributed Extensions and Additions to PostgreSQL | package
i+ | postgresql16-server | The Programs Needed to Create and Run a PostgreS-> | package
AC3:
postgresql:~ # systemctl is-system-running
running
qam2:~ # systemctl is-system-running
running
I guess all done.
Actions