From: Matthias.Pitzl@izb.de
To: rickard.sjostrom@bluebottle.com
To: pgsql-admin@postgresql.org
Subject: Re: Upgrading from 7.4 to 8.2
Date: Tue, 19 Dec 2006 10:29:17 +0100
Message-ID: <11EC9A592C31034C88965C87AF18C2A70CFD5D@m0000s61> (raw)
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: Matthias.Pitzl@izb.de, rickard.sjostrom@bluebottle.com
Subject: Re: Upgrading from 7.4 to 8.2
In-Reply-To: <11EC9A592C31034C88965C87AF18C2A70CFD5D@m0000s61>
References: <11EC9A592C31034C88965C87AF18C2A70CFD5D@m0000s61>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox