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 about 3 years ago.
Updated almost 3 years ago.
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 :)
- Copied from action #76927: Upgrade postgresql database version on osd to default of Leap 15.2, like on o3 size:M added
- 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)
- Priority changed from Normal to Low
- Target version changed from Ready to future
- Target version changed from future to Ready
- 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
- Status changed from New to Feedback
database upgraded, old postgresql packages removed
old database still in /srv/PSQL/data.12
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.
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.
- Status changed from Feedback to Resolved
Also available in: Atom
PDF