Hi! Thanks for your replies! My problem is that I want to move the DBM to a different machine so now when it doesn't seem to be any easy/trivial way to migrate from 7.4 to 8.2 I might consider to continue with 7.4. If I decide to continue with 7.4 I guess the procedure to move the DATADIR to the new machine and then start the postgresql server there with the old DATADIR should work without problems? Thanks, again! /Rickard Citerar Rajesh Kumar Mallah <mallah.rajesh@xxxxxxxxx>: > Dear Rickard, > > The jump from 7.4 to 8.2 is rather big. > I would suggest doing just a dry run by dumping > the database schema without data and restoring it > into 8.2 database . this can be time saving in detecting > possible problems in migration. > > in case there is some non trivial problem > you may take intermediate path of upgrading > 7.4-->8.0.x-->8.1.x -->8.2.0 > where x denotes the last minor release of a major > release. > > regds > mallah. > > > On 12/19/06, Matthias.Pitzl@xxxxxx <Matthias.Pitzl@xxxxxx> wrote: > > Hi Rickard! > > > > As far as i know you will have to dump and restore the databases > for the > > upgrade since a lot of internals have been changed from 7.4 to > 8.2. > > A description on how to upgrade can be found here: > > > http://www.postgresql.org/docs/8.2/interactive/install-upgrading.html > > And here: > http://www.postgresql.org/docs/8.2/interactive/migration.html > > > > Good luck! > > > > Greetings, > > Matthias > > > > > -----Original Message----- > > > From: pgsql-admin-owner@xxxxxxxxxxxxxx > > > [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of > > > Rickard Sjöström > > > Sent: Tuesday, December 19, 2006 10:04 AM > > > To: pgsql-admin@xxxxxxxxxxxxxx > > > Subject: [ADMIN] Upgrading from 7.4 to 8.2 > > > > > > > > > Hi! > > > I have PostgreSQL 7.4 DBM and want to upgrade to 8.2 (latest > > > in version 8 I quess). > > > > > > Can use the DATADIR from 7.4 and just upgrade the > > > DBM/postgresql server to 8.2? > > > > > > Is the upgrade from 7 to 8 procedure written down somewhere? > > > (could not find anyting at > > > http://www.postgresql.org/docs/techdocs.2, > except from 6 to > > > 7) > > > > > > I guess I could dump all my data and restore it later but it > > > would be much nicer if it was possible to just start a new > > > PostgreSQL server with the old DATADIR repository! > > > > > > Thanks! > > > > > > /Rick > > > > > > > ---------------------------------------------------------------------- > > > Diamond Ring Auctions at Bidz! > > > Engagement rings auctioned daily. Every 5 seconds, starting at > $1! > > > > http://tags.bluebottle.com/fc/BgLEQfJCfpRhST38x1THooDD28i6CkYTg1zn/ > > > > > > > > > ---------------------------(end of > > > broadcast)--------------------------- > > > TIP 5: don't forget to increase your free space map settings > > > > > > > ---------------------------(end of > broadcast)--------------------------- > > TIP 1: if posting/reading through Usenet, please send an > appropriate > > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so > that your > > message can get through to the mailing list cleanly > > > ---------------------------------------------------------------------- Free Debt Consolidation Quote FCCC offers free counseling & debt consolidation quote. No setup fee! http://tags.bluebottle.com/fc/BgLEQfI7q8COE6YTwzNhNIsdKPTGDJaJS3gO/
