Thread: Re: Upgrade Information
> > > If so, that seems pretty drastic. I cannot imagine that once our > > databases > > > start getting really huge that this will last as an upgrade method. I > > > thought we would be using pg_upgrade, but I see a note that it will not > > > work with versions of postgres 7.1 and higher. > > > > > > Why did pg_upgrade go away, and can we look forward to one in the future? > > > >It is in /contrib/pg_upgrade now and it does work for 7.1 upgrades, > >though it is only lightly tested. > > Bruce, are you saying I can use /contrib/pg_upgrade for my 7.1.2 to 7.2 > upgrade? Yes, absolutely. At least it worked in my tests. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> Bruce, are you saying I can use /contrib/pg_upgrade for my 7.1.2 to 7.2
>> upgrade?
> Yes, absolutely. At least it worked in my tests.
However, it'd be folly not to make a dump beforehand, so you can recover
if it doesn't work ...
regards, tom lane
Tom Lane wrote: > Bruce Momjian <pgman@candle.pha.pa.us> writes: > >> Bruce, are you saying I can use /contrib/pg_upgrade for my 7.1.2 to 7.2 > >> upgrade? > > > Yes, absolutely. At least it worked in my tests. > > However, it'd be folly not to make a dump beforehand, so you can recover > if it doesn't work ... Oh, yes, as it says in the manual page, do a backup first and report back how it works. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Chad R. Larson wrote: > At 11:53 AM 2/8/2002 , Bruce Momjian wrote: > >It is in /contrib/pg_upgrade now and it does work for 7.1 upgrades, > >though it is only lightly tested. > > When you say "work for 7.1 upgrades" I assume you mean like from 7.1.2 to > 7.1.3. Is there a 7.1.2 to 7.2 version? Would one be hard to write, given > the existing one as a model? Upgrades 7.1.X to 7.2. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026