Re: minimizing downtime when upgrading - Mailing list pgsql-general

From Richard Huxton
Subject Re: minimizing downtime when upgrading
Date
Msg-id 4492A1D3.1040301@archonet.com
Whole thread Raw
In response to Re: minimizing downtime when upgrading  (Kenneth Downs <ken@secdat.com>)
Responses Re: minimizing downtime when upgrading  (Kenneth Downs <ken@secdat.com>)
List pgsql-general
Kenneth Downs wrote:
> AFAIK it has always been the case that you should expect to have to dump
> out your databases and reload them for version upgrades.
>
> Is anybody over at the dev team considering what an onerous burden this
> is?  Is anyone considering doing away with it?

Far from trivial. You have changes in on-disk formats and actual
functionality between major version numbers. For instance - what would
you do to deal with the recent changes in unicode validation?

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: "Nitin Verma"
Date:
Subject: Re: VACUUMing sometimes increasing database size / sometimes
Next
From: Richard Huxton
Date:
Subject: Re: VACUUMing sometimes increasing database size / sometimes