Re: Why dump/restore to upgrade?

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: mlw <markw@mohawksoft.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2002-02-08T05:44:07Z
Lists: pgsql-hackers
mlw <markw@mohawksoft.com> writes:
> but I'd like to make a general call to arms that this (or 7.3) should be the
> last release to require this.

We will never make such a commitment, at least not in the foreseeable
future.

I would like to see more attention paid to supporting cross-version
upgrades via pg_upgrade (or some improved version thereof) when
practical, which it should be more often than not.  But to bind
ourselves forever to the current on-disk format is sheer folly.
And if you have to convert the datafile format then you might as
well dump and reload.

			regards, tom lane