Tom Lane wrote:
> The system tables are not the problem.  pg_upgrade has shown how we
> can have cross-version upgrades no matter how much the system catalogs
> change (a good thing too, because we cannot freeze the system catalog
> layout without bringing development to a standstill).  A schema-only
> dump and restore is cheap enough that there's no real reason to look
> for any other solution.
> 
> Changes in the on-disk representation of user tables would be harder to
> deal with, but they are also much rarer (AFAIR we've only done that
> twice: WAL required additions to page and tuple headers, and then there
> were Manfred's space-saving changes in 7.3).  And as of 7.3 there is a
> version field in page headers, which would in theory allow for a
> page-at-a-time update process to work.
> 
> There isn't any fundamental reason why we cannot have a pg_upgrade
> utility; claiming that there is something wrong with how we handle
> catalog changes misses the point.  The point is that *someone would
> have to do the work*.  Unless someone wants to step up and volunteer,
> there's little value in discussing it.

pg_upgrade does work, assuming there are no changes to the index or heap
file formats.  (However, I now need to update it for schemas.)  However,
the last time I worked on it for 7.2, no one was really interested in
testing it, so it never got done.  In fact, there was a bug in the
handling of clog or wal files, but I didn't find out about it until long
after 7.2 because no one was using it.

Is pg_upgrade too hard to run?  Is no one really interested in it?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

• Re: Upgrading rant. at 2003-01-03 20:37:56 from Tom Lane

Responses

• Re: Upgrading rant. at 2003-01-04 00:14:17 from Serguei Mokhov
• Re: Upgrading rant. at 2003-01-04 01:19:20 from Tom Lane
• Re: Upgrading rant. at 2003-01-04 01:32:15 from Lamar Owen
• Re: Upgrading rant. at 2003-01-04 02:17:39 from Tom Lane
• Re: Upgrading rant. at 2003-01-04 04:16:26 from Dan Langille
• Re: Upgrading rant. at 2003-01-04 05:39:37 from Christopher Kings-Lynne
• Re: Upgrading rant. at 2003-01-05 16:36:16 from mlw
• Re: Upgrading rant. at 2003-01-06 18:06:51 from Thomas O'Connell

pgsql-hackers by date

Next:	From: Serguei Mokhov	Date: 2003-01-03 23:41:33
	Subject: Re: pg_dump.options.diff -- Take III
Previous:	From: Florian Weimer	Date: 2003-01-03 23:18:55
	Subject: Re: why was libpq.so's version number bumped?