Project

General

Profile

Actions
Copy link

action #99204

closed

coordination #99183: [epic] Upgrade all our infrastructure, e.g. o3+osd workers+webui, to openSUSE Leap 15.3

Upgrade postgresql database version on osd to default of Leap 15.3, like on o3

Added by okurz over 2 years ago. Updated over 2 years ago.

Status:
Resolved
Priority:
Low
Assignee:
osukup
Category:
-
Target version:
openQA Project - Ready
Start date:
Due date:
% Done:

0%

Estimated time:

Description

Motivation

See #76924

Acceptance criteria

  • AC1: osd runs openQA from a postgres13 database
  • AC2: no severe functional or performance related impact has been observed

Suggestions

  • Same as in #76924 but done by a different person to improve our bus factor :)

Related issues 1 (0 open — 1 closed)

Copied from openQA Infrastructure - action #76927: Upgrade postgresql database version on osd to default of Leap 15.2, like on o3 size:MResolvedosukup2020-11-03

Actions
Actions
Copy link
 #1

Updated by okurz over 2 years ago

  • Copied from action #76927: Upgrade postgresql database version on osd to default of Leap 15.2, like on o3 size:M added
Actions
Copy link
 #2

Updated by okurz over 2 years ago

  • Subject changed from Upgrade postgresql database version on osd to default of Leap 15.2, like on o3 size:M to Upgrade postgresql database version on osd to default of Leap 15.3, like on o3 size:M
  • Description updated (diff)
  • Priority changed from High to Normal
  • Start date deleted (2020-11-03)
Actions
Copy link
 #3

Updated by okurz over 2 years ago

  • Priority changed from Normal to Low
Actions
Copy link
 #4

Updated by okurz over 2 years ago

  • Target version changed from Ready to future
Actions
Copy link
 #5

Updated by okurz over 2 years ago

  • Target version changed from future to Ready
Actions
Copy link
 #6

Updated by osukup over 2 years ago

  • Assignee set to osukup
Actions
Copy link
 #7

Updated by livdywan over 2 years ago

  • Subject changed from Upgrade postgresql database version on osd to default of Leap 15.3, like on o3 size:M to Upgrade postgresql database version on osd to default of Leap 15.3, like on o3

size:M seems to have been copied w/o the ticket having been estimated

Actions
Copy link
 #8

Updated by osukup over 2 years ago

  • Status changed from New to Feedback

database upgraded, old postgresql packages removed

old database still in /srv/PSQL/data.12

Actions
Copy link
 #9

Updated by okurz over 2 years ago

There was a problem accessing the PostgreSQL database from outside localhost, see https://suse.slack.com/archives/C02CANHLANP/p1641391274165900 . Seems like osukup missed to take over custom settings from the postgres config files. I fixed this by enabling the line about "listen_addresses" and apply a salt high state on OSD.

Actions
Copy link
 #10

Updated by osukup over 2 years ago

okurz wrote:

There was a problem accessing the PostgreSQL database from outside localhost, see https://suse.slack.com/archives/C02CANHLANP/p1641391274165900 . Seems like osukup missed to take over custom settings from the postgres config files. I fixed this by enabling the line about "listen_addresses" and apply a salt high state on OSD.

thx, it really seems I missed this line

btw: postgre 14 has new defaults for logging, because it wasn't modified by us I didn't change this to old defaults. The question is if this change affects us.

Actions
Copy link
 #11

Updated by osukup over 2 years ago

  • Status changed from Feedback to Resolved
Actions
Copy link

Also available in: Atom PDF