Re: Speaking of upgrades... (was Re: Predicted ...)

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Speaking of upgrades... (was Re: Predicted ...)
Date: 2007-01-27 06:29:26
Message-ID: 45BAF146.505@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 01/27/07 00:19, Martijn van Oosterhout wrote:
> On Fri, Jan 26, 2007 at 10:16:39PM -0600, Ron Johnson wrote:
>> What are your plans for reducing the number of resources needed to
>> upgrade databases?
>
> As noted, the table structure changes only slightly between versions,
> if at all. What does change significantly is the catalog. Even now
> there have been significant underlying changes to make the catalog
> totally incompatable. There has been work on a pg_upgrade tool which
> would create a new database with the new version and then copy the data
> tables from the old version and rebuild the indexes. The idea being
> that the data is large, but the underlying system is fairly small.

You mean "copy just the system catalog"?

> In theory it could work, but I don't know about the status. There has
> been some support from the core that *if* such a pg_upgrade tool
> existed, *then* they would provide some backward compatability for he
> datatypes.

That's how the system I use at work does upgrades. The existing
user data formats don't change, but the system catalog does. So,
when you convert a DB, it makes a fresh copy of the catalog, and
then migrates the old catalog to the new catalog. 15 year old
systems can be upgraded that way, with no harm to the user data.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFuvFGS9HxQb37XmcRAmyhAJ9bTG8cVB1vYk8YMWDeIXTuC49QXQCgqOAe
zzqCCBcZn9UdddvJKKw4vYM=
=3mVM
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2007-01-27 08:41:11 Re: Predicted lifespan of different PostgreSQL branches
Previous Message Tom Lane 2007-01-27 06:19:31 Re: Predicted lifespan of different PostgreSQL branches