Re: minimizing downtime when upgrading

From: Richard Huxton <dev(at)archonet(dot)com>
To: Kenneth Downs <ken(at)secdat(dot)com>
Cc: snacktime <snacktime(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: minimizing downtime when upgrading
Date: 2006-06-16 12:19:31
Message-ID: 4492A1D3.1040301@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-06-16 12:59:08 Re: VACUUMing sometimes increasing database size / sometimes
Previous Message Nitin Verma 2006-06-16 12:04:50 Re: VACUUMing sometimes increasing database size / sometimes