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 >
