Re: Redhat 7 and PgSQL

So we can say that we can upgrade, at least in theory, but that's not the
official policy?

----- Original Message -----
From: <bmccoy@chapelperilous.net>
To: "Trond Eivind Glomsrød" <teg@redhat.com>
Cc: "Efrain Caro" <betsemes@hotmail.com>; "Jeff Hoffmann"
<jeff@propertykey.com>; <pgsql-general@postgresql.org>
Sent: Friday, September 29, 2000 11:36 AM
Subject: Re: [GENERAL] Redhat 7 and PgSQL


On 29 Sep 2000, Trond Eivind Glomsrød wrote:

> That you can't upgrade postgresql from e.g. 6.5 to 7.0 or from 7.0 to
> 7.1
>
> Incidentally, you can dump data from a database. You can also insert
> data into a database. If you do this before and after upgrading,
> you'll hopefully have the same data in the database.

FWIW, that's pretty tame compared to trying to migrate and upgrade an
Oracle database.  Have you ever seen some of the upgrade path rules for
Oracle?  If it's this version, first migrate to this version and then
upgrade, but if it's this other version, then it can upgrade directly,
unless it's the beta version, then you have to migrate blah blah blah...

Is it feasible to create a 'universal installer' for PostgreSQL similar to
what Oracle has (especially for binary distributions) that will do the
data migration behind the scenes?  Doing the source compile will probably
require migrating the stuff manually (but if you are installing from
source, you are doing everything manually *anyway*).

Brett W. McCoy
                                              http://www.chapelperilous.net
---------------------------------------------------------------------------
WHO sees a BEACH BUNNY sobbing on a SHAG RUG?!