Project

General

Profile

Actions
Copy link

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 5 months ago. Updated 4 months ago.

Status:
Resolved
Priority:
Normal
Assignee:
jbaier_cz
Category:
Organisational
Target version:
Ready
Start date:
2024-07-22
Due date:
% Done:

0%

Estimated time:
Tags:
infra

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

Related issues 1 (0 open — 1 closed)

Copied from openQA Project (public) - action #157987: Upgrade qam hosts maintained by us to latest stable, i.e. Leap 15.6Resolvedjbaier_cz

Actions
Actions
Copy link
 #1

Updated by okurz 5 months ago

  • Copied from action #157987: Upgrade qam hosts maintained by us to latest stable, i.e. Leap 15.6 added
Actions
Copy link
 #2

Updated by okurz 4 months ago

  • Target version changed from Tools - Next to Ready
Actions
Copy link
 #3

Updated by okurz 4 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
Actions
Copy link
 #4

Updated by jbaier_cz 4 months ago

  • Assignee set to jbaier_cz
Actions
Copy link
 #5

Updated by jbaier_cz 4 months ago

  • Status changed from Workable to In Progress
Actions
Copy link
 #6

Updated by jbaier_cz 4 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
Copy link

Also available in: Atom PDF