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@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of
> Rickard Sjöström
> Sent: Tuesday, December 19, 2006 10:04 AM
> To: pgsql-admin@postgresql.org
> 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
>