Re: 7.2.3-7.4.2 migration

Thanks for your advices.

Christophe

Le jeu 01/04/2004 à 17:28, Tom Lane a écrit :

> Richard Huxton <dev(at)archonet(dot)com> writes:
> > On Thursday 01 April 2004 12:12, Christophe Musielak wrote:
> >> First, is it possible to upgrade directly from 7.2.3 --> 7.4.2 : ie dump
> >> the 7.2.3 datas, upgrade to 7.4.2, then restore the 7.2.3 datas?
> >> or shall we do 7.3 upgrade, restore datas, dump, then 7.4 db upgrade,
> >> restore datas?
>
> > I don't think you'd gain anything by doing the upgrade in two steps.
>
> I agree; that just doubles the work. One note: you'd be well advised to
> execute the dump using 7.4's pg_dump rather than 7.2's. Later pg_dumps
> often fix problems in earlier ones.
>
> > I tend to do a schema-only followed by a data-only restore.
>
> That will slow things down a bit because indexes and foreign keys will
> be built/checked incrementally rather than in one go. What I definitely
> *would* recommend is trying a schema-only dump first to check for
> problems. If that loads, drop it again and go for a full dump. If not,
> you can work out a solution without pushing so much data around ...
>
> regards, tom lane