action #164299
closed
coordination #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
Added by okurz 4 months ago.
Updated 3 months ago.
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¶
- Copied from action #157987: Upgrade qam hosts maintained by us to latest stable, i.e. Leap 15.6 added
- Target version changed from Tools - Next to Ready
- 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
- Assignee set to jbaier_cz
- Status changed from Workable to In Progress
- 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.
Also available in: Atom
PDF