pgsql: pg_upgrade: only allow template0 to be non-connectable - Mailing list pgsql-committers

From Bruce Momjian
Subject pgsql: pg_upgrade: only allow template0 to be non-connectable
Date
Msg-id E1YtTQU-0000lt-6K@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
pg_upgrade:  only allow template0 to be non-connectable

This patch causes pg_upgrade to error out during its check phase if:

(1) template0 is marked connectable
or
(2) any other database is marked non-connectable

This is done because, in the first case, pg_upgrade would fail because
the pg_dumpall --globals restore would fail, and in the second case, the
database would not be restored, leading to data loss.

Report by Matt Landry (1), Stephen Frost (2)

Backpatch through 9.0

Branch
------
REL9_3_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/4cfba536981e7584bd051de3e1bcbe7e36a9605b

Modified Files
--------------
contrib/pg_upgrade/check.c |   54 ++++++++++++++++++++++++++++++++++++++++++++
1 file changed, 54 insertions(+)


pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: pgsql: pg_upgrade: only allow template0 to be non-connectable
Next
From: Bruce Momjian
Date:
Subject: pgsql: pg_upgrade: only allow template0 to be non-connectable