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

On Tue, 2006-12-19 at 16:40 -0500, Chris Hoover wrote:
> Very easy,
>
> Install the new version of PostgreSQL on your new machine.  Then use
> the new machine's install to pg_dump the old machine's database and
> load it into the new machine (obviously, the machines must be table to
> talk to each other over the network).  Very easy.  That is how I
> upgraded all of my servers from 7.3.4 to 8.1.3. (An upgrade that went
> very smoothly with no hiccups.)

Except that there are behavioral differences between 8.1.3 and 7.4
including how floats respond to '' input. I believe there are also
library version bumps which will likely effect him if he does not
recompile his apps because he might remove 7.4 after getting a
successful upgrade of his data just to find that PHP or Perl doesn't
work anymore.

Joshua D. Drake


>
> HTH,
>
> Chris
>
> On 12/19/06, Rickard Sjöström <rickard.sjostrom@bluebottle.com> wrote:
>         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
>
--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate