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
