pgsql: Fix pg_upgrade failure from servers older than 9.3

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix pg_upgrade failure from servers older than 9.3
Date: 2013-08-19 16:57:12
Message-ID: E1VBSlU-00025k-NX@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix pg_upgrade failure from servers older than 9.3

When upgrading from servers of versions 9.2 and older, and MultiXactIds
have been used in the old server beyond the first page (that is, 2048
multis or more in the default 8kB-page build), pg_upgrade would set the
next multixact offset to use beyond what has been allocated in the new
cluster. This would cause a failure the first time the new cluster
needs to use this value, because the pg_multixact/offsets/ file wouldn't
exist or wouldn't be large enough. To fix, ensure that the transient
server instances launched by pg_upgrade extend the file as necessary.

Per report from Jesse Denardo in
CANiVXAj4c88YqipsyFQPboqMudnjcNTdB3pqe8ReXqAFQ=HXyA(at)mail(dot)gmail(dot)com

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/78e1220104227c86b4b49d0fc123db7fa596d43d

Modified Files
--------------
src/backend/access/transam/multixact.c | 47 ++++++++++++++++++++++++++++++++
src/backend/access/transam/slru.c | 44 ++++++++++++++++++++++++++++++
src/include/access/slru.h | 1 +
3 files changed, 92 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2013-08-19 17:19:59 pgsql: Fix qual-clause-misplacement issues with pulled-up LATERAL subqu
Previous Message Bruce Momjian 2013-08-19 16:26:30 pgsql: release notes: remove username from 9.3 major item