From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: Matthias.Pitzl@izb.de <Matthias.Pitzl@izb.de>
Cc: rickard.sjostrom@bluebottle.com
Cc: pgsql-admin@postgresql.org
Subject: Re: Upgrading from 7.4 to 8.2
Date: Tue, 19 Dec 2006 20:47:22 +0530
Message-ID: <a97c77030612190717p1d3423a4h9b793cf929b6cb1@mail.gmail.com> (raw)
In-Reply-To: <11EC9A592C31034C88965C87AF18C2A70CFD5D@m0000s61>
References: <11EC9A592C31034C88965C87AF18C2A70CFD5D@m0000s61>
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@izb.de <Matthias.Pitzl@izb.de> 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@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
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
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: mallah.rajesh@gmail.com, Matthias.Pitzl@izb.de, rickard.sjostrom@bluebottle.com
Subject: Re: Upgrading from 7.4 to 8.2
In-Reply-To: <a97c77030612190717p1d3423a4h9b793cf929b6cb1@mail.gmail.com>
References: <11EC9A592C31034C88965C87AF18C2A70CFD5D@m0000s61> <a97c77030612190717p1d3423a4h9b793cf929b6cb1@mail.gmail.com>
* 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