Re: upgrading postgresql

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(at)crankycanuck(dot)ca
This work was visionary and imaginative, and goes to show that visionary
and imaginative work need not end up well.
--Dennis Ritchie