Re: Upgrading from 7.1

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: jvilla(at)innovativesource(dot)net, pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrading from 7.1
Date: 2005-07-27 18:46:42
Message-ID: 200507271146.43551.scrawford@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 27 July 2005 11:41 am, Jonathan Villa wrote:
> I've been googling a little bit and appears that 7.1 pretty old.

Very.

> What steps are advised to upgrade from 7.1 to 7.4?

Unless there is some reason you really need 7.4, just go straight to
8.0.3.

Instructions start on page 230 of the PG8 documentation. Basically you
do a pg_dumpall to backup your old database (make sure it is not
being updated), stop the old server, install the new server, restore
your data:
http://www.postgresql.org/docs/8.0/interactive/install-upgrading.html

Cheers,
Steve

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-07-27 19:00:27 Re: Upgrading from 7.1
Previous Message Scott Marlowe 2005-07-27 18:44:47 Re: Upgrading from 7.1