Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5042D9FA1FD for ; Tue, 19 Dec 2006 05:32:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 03448-02 for ; Tue, 19 Dec 2006 05:32:36 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from smx2-izb.izb.net (smx2-izb.izb.net [212.34.66.102]) by postgresql.org (Postfix) with SMTP id 71BE39F9398 for ; Tue, 19 Dec 2006 05:32:39 -0400 (AST) Received: from m0000s0b.co.ins.izb.de (unknown [172.20.166.33]) by smx2-izb.izb.net (Postfix) with ESMTP id 140FF31F2A5; Tue, 19 Dec 2006 10:32:31 +0100 (CET) Received: by M0000S0B with Internet Mail Service (5.5.2653.19) id ; Tue, 19 Dec 2006 10:32:27 +0100 Message-ID: <11EC9A592C31034C88965C87AF18C2A70CFD5D@m0000s61> From: Matthias.Pitzl@izb.de To: rickard.sjostrom@bluebottle.com, pgsql-admin@postgresql.org Subject: Re: Upgrading from 7.4 to 8.2 Date: Tue, 19 Dec 2006 10:29:17 +0100 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-IZB-OE30173-MailScanner-Information: Please contact IZB/OE30173/+49 89 94511 8833 for more information X-IZB-OE30173-MailScanner: Found to be clean X-IZB-OE30173-MailScanner-SpamCheck: not spam (whitelisted), SpamAssassin (score=-0.89, required 3, ALL_TRUSTED -1.44, NO_REAL_NAME 0.55) X-MailScanner-From: matthias.pitzl@izb.de X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/258 X-Sequence-Number: 24050 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=20 > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of=20 > Rickard Sj=F6str=F6m > Sent: Tuesday, December 19, 2006 10:04 AM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] Upgrading from 7.4 to 8.2 >=20 >=20 > Hi! > I have PostgreSQL 7.4 DBM and want to upgrade to 8.2 (latest=20 > in version 8 I quess). >=20 > Can use the DATADIR from 7.4 and just upgrade the=20 > DBM/postgresql server to 8.2? >=20 > Is the upgrade from 7 to 8 procedure written down somewhere?=20 > (could not find anyting at=20 > http://www.postgresql.org/docs/techdocs.2, > except from 6 to=20 > 7) >=20 > I guess I could dump all my data and restore it later but it=20 > would be much nicer if it was possible to just start a new=20 > PostgreSQL server with the old DATADIR repository! >=20 > Thanks! >=20 > /Rick >=20 > = ---------------------------------------------------------------------- > Diamond Ring Auctions at Bidz! > Engagement rings auctioned daily. Every 5 seconds, starting at $1! > http://tags.bluebottle.com/fc/BgLEQfJCfpRhST38x1THooDD28i6CkYTg1zn/ >=20 >=20 > ---------------------------(end of=20 > broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >=20