Re: Details for planned template0/template1 change - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Details for planned template0/template1 change
Date
Msg-id 9857.974136129@sss.pgh.pa.us
Whole thread Raw
In response to Re: Details for planned template0/template1 change  (Lamar Owen <lamar.owen@wgcr.org>)
List pgsql-hackers
Lamar Owen <lamar.owen@wgcr.org> writes:
> That is a great side-effect.  Now, if there were a way to initdb just
> template0, leaving everything else in place, then rebuilding template1
> -- of course, a similar ability is there now, but the two-stage initdb
> this implies could make pg_upgrade work smoother, in cases where the
> system catalogs are the only change from one major version to the next.

I'm missing something --- I don't see how this affects pg_upgrade one
way or the other, except of course that it should be prepared to cope
with user data in template1 (not sure if it does or not now).

pg_upgrade won't be usable for the 7.1 transition anyway, because of WAL
changes (page header format is changing).  I dunno whether it will be
usable at all under WAL --- Vadim will have to comment on that.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Details for planned template0/template1 change
Next
From: Philip Warner
Date:
Subject: Re: Details for planned template0/template1 change