Skip site navigation (1) Skip section navigation (2)

Re: upgrading postgresql

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: upgrading postgresql
Date: 2004-12-15 18:15:23
Message-ID: 20041215181523.GC31560@phlogiston.dyndns.org (view raw or flat)
Thread:
Lists: 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(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

In response to

pgsql-admin by date

Next:From: William YuDate: 2004-12-15 23:29:58
Subject: Re: Tyan Thunder MB for postgres server
Previous:From: Michael FuhrDate: 2004-12-15 16:59:43
Subject: Re: [Re]:User Admin in pgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group