Re: State of Beta 2 - Mailing list pgsql-general

From Tom Lane
Subject Re: State of Beta 2
Date
Msg-id 9097.1064007493@sss.pgh.pa.us
Whole thread Raw
In response to Re: State of Beta 2  (Manfred Koizar <mkoi-pg@aon.at>)
Responses Re: State of Beta 2  ("Marc G. Fournier" <scrappy@postgresql.org>)
List pgsql-general
Manfred Koizar <mkoi-pg@aon.at> writes:
> Elsewhere in this current thread it has been suggested that the
> on-disk format will stabilize at some time in the future and should
> then be frozen to ensure painless upgrades.  IMHO, at the moment when
> data structures are declared stable and immutable the project is dead.

This is something that concerns me also.

> A working pg_upgrade is *not* the first thing we need.

Yes it is.  As you say later,

> ... But once the infrastructure is in place, things
> should get easier.

Until we have a working pg_upgrade, every little catalog change will
break backwards compatibility.  And I do not feel that the appropriate
way to handle catalog changes is to insist on one-off solutions for each
one.  Any quick look at the CVS logs will show that minor and major
catalog revisions occur *far* more frequently than changes that would
affect on-disk representation of user data.  If we had a working
pg_upgrade then I'd be willing to think about committing to "no user
data changes without an upgrade path" as project policy.  Without it,
any such policy would simply stop development in its tracks.

            regards, tom lane

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: need for in-place upgrades
Next
From: Christopher Browne
Date:
Subject: Re: OT: HEADS-UP: viral storm out there