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