Re: Upgrading from 7.4 to 8.2 - Mailing list pgsql-admin

Hi!
Thanks for your replies!

My problem is that I want to move the DBM to a different machine so now when it doesn't seem to be any easy/trivial way to migrate from 7.4 to 8.2 I might consider to continue with 7.4.

If I decide to continue with 7.4 I guess the procedure to move the DATADIR to the new machine and then start the postgresql server there with the old DATADIR should work without problems?

Thanks, again!

/Rickard

Citerar Rajesh Kumar Mallah < mallah.rajesh@gmail.com>:

> 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
> >
>

----------------------------------------------------------------------
Free Debt Consolidation Quote
FCCC offers free counseling & debt consolidation quote. No setup fee!
http://tags.bluebottle.com/fc/BgLEQfI7q8COE6YTwzNhNIsdKPTGDJaJS3gO/


---------------------------(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