pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
> 



view thread (9+ messages)  latest in thread

Message-ID: <11EC9A592C31034C88965C87AF18C2A70CFD5D@m0000s61>
Permalink:  ../11EC9A592C31034C88965C87AF18C2A70CFD5D@m0000s61/
Also on:    postgresql.org/message-id/11EC9A592C31034C88965C87AF18C2A70CFD5D@m0000s61

 · 

reply

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