Richard Huxton <dev@archonet.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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
