Project

General

Profile

Actions

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 3 months ago. Updated about 2 months ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
Organisational
Target version:
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


Related issues 1 (0 open1 closed)

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

Actions
Actions #1

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
Actions #2

Updated by okurz 2 months ago

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

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
Actions #4

Updated by jbaier_cz about 2 months ago

  • Assignee set to jbaier_cz
Actions #5

Updated by jbaier_cz about 2 months ago

  • Status changed from Workable to In Progress
Actions #6

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

Also available in: Atom PDF