PostgreSQL 16 images based on EL10 have an incorrect POSTGRESQL_PREV_VERSION set
Nobody has claimed this yet.
Assessment
- Difficulty
- 2/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 72/100
Research direction
Start with 16/Dockerfile.c10s at lines 13-14 and inspect how POSTGRESQL_PREV_VERSION is set for the CentOS Stream 10 image. Reproduce the upgrade with the provided Podman commands and verify the postgresql-upgrade package's PostgreSQL 13 binaries. Done means the default upgrade succeeds without explicitly setting POSTGRESQL_PREV_VERSION, while the CentOS Stream 9 behavior remains correctly documented.
Written by the indexing model from the issue text.
Description
Container platform
Podman/Docker
Version
quay.io/sclorg/postgresql-16-c10s and the equivalent RHEL image
OS version of the container image
CentOS Stream 10
Bugzilla, Jira
https://redhat.atlassian.net/browse/RHEL-191375
Description
The value for POSTGRESQL_PREV_VERSION in the CentOS Stream 10 container is set to 15, but the postgresql-upgrade package in CentOS Stream has the PostgreSQL 13 binaries. So this part is wrong:
It should be noted that the CentOS Stream 9 version of postgresql-upgrade for PostgreSQL does contain version 15 binaries so the documentation may end up a bit more complicated.
Reproducer
DATADIR=$(mktemp -d)
chmod 777 $DATADIR
podman run --rm -it -e POSTGRESQL_ADMIN_PASSWORD=hunter2 -v $DATADIR:/var/lib/pgsql/data:Z quay.io/sclorg/postgresql-13-c9s
podman run --rm -it -e POSTGRESQL_ADMIN_PASSWORD=hunter2 -e POSTGRESQL_UPGRADE=hardlink -v $DATADIR:/var/lib/pgsql/data:Z quay.io/sclorg/postgresql-16-c10s
This fails, but when I use e POSTGRESQL_PREV_VERSION=13 as well the it can upgrade.
Copy-pasted from https://github.com/theforeman/foremanctl/pull/577#issuecomment-4832709364
% podman run --rm -ti quay.io/sclorg/postgresql-16-c10s bash
…
bash-5.2$ rpm -q postgresql-upgrade
postgresql-upgrade-16.13-2.el10.x86_64
bash-5.2$ rpm -qf /usr/lib64/pgsql/postgresql-13/bin/postgres
postgresql-upgrade-16.13-2.el10.x86_64
bash-5.2$ /usr/lib64/pgsql/postgresql-13/bin/postgres --version
postgres (PostgreSQL) 13.23
- Dominant language
- PLpgSQL
- Stars
- 178
- Forks
- 220
- PR merge metrics
- No merged PRs in 30d
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from sclorg/postgresql-container
-
Difficulty 3/5 1-2 days Newbie friendliness 68/100
sclorg/postgresql-container#669 · 1 comment ·
-
Difficulty 3/5 1-2 days Newbie friendliness 52/100
sclorg/postgresql-container#668 ·
-
Dockerfile failing Open
Difficulty 2/5 1-3 hours Newbie friendliness 55/100
sclorg/postgresql-container#656 ·
-
Difficulty 3/5 1-2 days Newbie friendliness 50/100
sclorg/postgresql-container#654 ·
-
sclorg/postgresql-container#605 · 10 comments · 1 assignee ·
All issues in sclorg/postgresql-container
Similar issues
-
bug: AI Gateway client filter lists "Unknown" twice when NULL and literal Unknown clients coexist Openbug
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
-
[BUG] A column whose default is the empty string is drawn in the ER diagram as having no default Openbug database-provider good first issue hacktoberfest
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
libredb/libredb-studio#1030 · 6 comments ·
-
comp-datalake
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
ClickHouse/ClickHouse#121222 ·
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
bug redshift
Difficulty 2/5 1-3 hours Newbie friendliness 88/100