Re: data format problem for upgrede from 7.1->7.3

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Oli Sennhauser <oli(dot)sennhauser(at)bluewin(dot)ch>
Cc: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: data format problem for upgrede from 7.1->7.3
Date: 2003-11-06 02:44:26
Message-ID: 20031106024426.GB12926@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Nov 06, 2003 at 00:27:03 +0100,
Oli Sennhauser <oli(dot)sennhauser(at)bluewin(dot)ch> wrote:
>
> If somebody is telling me now, I have to do this several times a year
> (how can I sell this to a customer???)... It is not a problem handling a
> micky-mouse database. dump/load 100 GB I would gess it takes me more
> than 12 h, 2 or 4 times a year makes an availability of less than 99%.
> If I have 1 TB...???

More like once a year. Only upgrades between major releases (e.g. 7.3.x
to 7.4.x) require dump and reloads.

People are looking at trying to do something about this, but it won't
happen for 7.4. Maybe by the time 7.5 is released there will be a better
way to upgrade.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Rudi Starcevic 2003-11-06 05:55:50 Process Files
Previous Message ezrapostgres 2003-11-06 01:34:49 Re: i dont wamt more mails