pgsql: Fix pg_upgrade from version 9.2

From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix pg_upgrade from version 9.2
Date: 2026-09-24 10:18:13
Message-ID: E1x9gWr-000000012pV-2dhi@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix pg_upgrade from version 9.2

Commit 7f25eccf41 added a cross-check between pg_database.datminmxid
and oldestMulti, but because PostgreSQL 9.2 doesn't have datminmxid,
it broke upgrade from version 9.2. Disable the check when upgrading
from 9.2 to fix.

This is for REL_19_STABLE only. Earlier versions don't have the check,
and on 'master' we no longer support upgrading from version 9.2.

Reported-by: Andrew Dunstan <andrew(at)dunslane(dot)net>
Discussion: https://www.postgresql.org/message-id/baef33d6-0416-48db-8e4d-0529a10a101a@dunslane.net

Branch
------
REL_19_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/2ae589741df0fa626386aa10b679f7ffb67b0b09

Modified Files
--------------
src/bin/pg_upgrade/check.c | 9 +++++++++
1 file changed, 9 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Álvaro Herrera 2026-09-24 10:18:34 pgsql: Wait for transactions of an initial decoding snapshot to commit
Previous Message Peter Eisentraut 2026-09-24 09:23:16 pgsql: Use warning option -Wshadow=local