Project

General

Profile

action #99204

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

Status:
Resolved
Priority:
Low
Assignee:
Target version:
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

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

History

#1 Updated by okurz 4 months ago

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

#2 Updated by okurz 4 months 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)

#3 Updated by okurz 4 months ago

  • Priority changed from Normal to Low

#4 Updated by okurz 4 months ago

  • Target version changed from Ready to future

#5 Updated by okurz about 1 month ago

  • Target version changed from future to Ready

#6 Updated by osukup about 1 month ago

  • Assignee set to osukup

#7 Updated by cdywan about 1 month 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

#8 Updated by osukup 23 days ago

  • Status changed from New to Feedback

database upgraded, old postgresql packages removed

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

#9 Updated by okurz 22 days 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.

#10 Updated by osukup 21 days 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.

#11 Updated by osukup 17 days ago

  • Status changed from Feedback to Resolved

Also available in: Atom PDF