Re: 7.2.3? - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: 7.2.3?
Date
Msg-id 200209290123.g8T1NVt03541@candle.pha.pa.us
Whole thread Raw
In response to Re: 7.2.3?  (Justin Clift <justin@postgresql.org>)
Responses Re: 7.2.3?  (Lamar Owen <lamar.owen@wgcr.org>)
Re: 7.2.3?  (Alvaro Herrera <alvherre@atentus.com>)
List pgsql-hackers
Justin Clift wrote:
> Alvaro Herrera wrote:
> <snip>
> > I agree with Lamar that upgrading is a very difficult process right now.
> > Requiring huge amounts of disk space and database downtime to do
> > dump/restore is in some cases too high a price to pay.  So maybe the
> > upgrading process should be observed instead of wasting time on people
> > trying to stay behind because of the price of that process.
> 
> As a "simple for the user approach", would it be
> too-difficult-to-bother-with to add to the postmaster an ability to
> start up with the data files from the previous version, for it to
> recognise an old data format automatically, then for it to do the
> conversion process of the old data format to the new one before going
> any further?
> 
> Sounds like a pain to create initially, but nifty in the end.

Yes, we could, but if we are going to do that, we may as well just
automate the dump/reload.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: DROP COLUMN misbehaviour with multiple inheritance
Next
From: Tom Lane
Date:
Subject: Re: Improving backend startup interlock