Re: Redhat 7 and PgSQL - Mailing list pgsql-general

From
Subject Re: Redhat 7 and PgSQL
Date
Msg-id Pine.LNX.4.10.10009291131240.18021-100000@chapelperilous.net
Whole thread Raw
In response to Re: Redhat 7 and PgSQL  (teg@redhat.com (Trond Eivind Glomsrød))
List pgsql-general
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?!


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: reldesc does not exit
Next
From: Tom Lane
Date:
Subject: Re: Redhat 7 and PgSQL