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

Ron Johnson wrote:
> > Yes:
> >
> >     http://www.postgresql.org/docs/8.2/static/migration.html
>
> I was thinking of something like the release notes, but a bit more
> targeted.  (I know.  diff the source.)
>
> http://www.postgresql.org/docs/8.2/interactive/release-8-2.html
>
> For example, I've read these release notes, and there are some index
> modifications, but don't *seem* to be *table* structure changes.
>
> So, in an upgrade from 8.1 to 8.2, what's really preventing pg from
> letting the user:
>
> 1. Cleanly shutdown pg.
> 2. Install v8.2.
> 3. Start pg.
> 4. psql -c 'REINDEX DATABASE' some_db

The changes are usually very subtle, like changes in the storage format
for certain data types, or bit changes in the row headers --- it isn't
something really of interest except to developers.

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +