Re: upgrading postgresql - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: upgrading postgresql
Date
Msg-id 20041215181523.GC31560@phlogiston.dyndns.org
Whole thread Raw
In response to Re: upgrading postgresql  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-admin
On Wed, Dec 15, 2004 at 10:20:00AM -0600, Scott Marlowe wrote:
> For upgrades from one major version to the next, you'll need to:
>
> -- pg_dump all databases in the cluster.  (optionally, also backup the
> files in the $PGDATA directory)

[&c.]

Or

-- install Slony-I
-- replicate from 7.3.x -> 7.4.y (where x >2)
-- catch up
-- move set

We've had quite a few reports of big successes upgrading this way; it
works well if you have the disk space.


A

--
Andrew Sullivan  | ajs@crankycanuck.ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
        --Dennis Ritchie

pgsql-admin by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: [Re]:User Admin in pgsql
Next
From: William Yu
Date:
Subject: Re: Tyan Thunder MB for postgres server