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

Re: Upgrading databases

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Cc: pgsql-interfaces(at)postgresql(dot)org MIME-Version: 1(dot)0 Content-Type: multipart/alternative; boundary="0-484458850-1257964711=:82692" X-Virus-Scanned: Maia Mailguard 1(dot)0(dot)1 X-Mailing-List: pgsql-interfaces List-Archive: <http://archives(dot)postgresql(dot)org/pgsql-interfaces> List-Help: <mailto:majordomo(at)postgresql(dot)org?body=help> List-ID: <pgsql-interfaces(dot)postgresql(dot)org> List-Owner: <mailto:pgsql-interfaces-owner(at)postgresql(dot)org> List-Post: <mailto:pgsql-interfaces(at)postgresql(dot)org> List-Subscribe: <mailto:majordomo(at)postgresql(dot)org?body=sub%20pgsql-interfaces> List-Unsubscribe: <mailto:majoMark Richardson <markmapo(at)yahoo(dot)com>
Subject: Re: Upgrading databases
Date: 2009-11-14 15:28:55
Message-ID: de22437dbe763bfecbe55e79827b7969@biglumber.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
-----BEGIN PGP SIGNED MESSAGE-----                            
Hash: RIPEMD160                                               


> I have a 8.2.4 database and I installed 8.3.7 and tried using the 
> same /pgsql/data/base directory and got an error about incompatiblity.
...
> Is there a conversion routine to change the files themselves? I know I can dump
> and reload - but that takes large disk space and time. Any other way around?

There are basically four ways to upgrade:

1. Dump and restore. As you mention, it is slow and non-concurrent. Very large
block of client downtime.

2. pg_migrator. Conversion of your current system to the new one. Much faster
than dump and restore, but only works for certain versions and has some minor
caveats. Requires medium client downtime.

3. Slony. Setup a slave database, get everything in sync, then switch over to the
new database. Very minimal downtime (seconds to minutes). Requires all tables
have primary keys.

4. Bucardo. Similar to the steps of Slony above. More forgiving of interruptions
in the original replication event.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation
PGP Key: 0x14964AC8 200911141026
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkr+zJcACgkQvJuQZxSWSsgd+gCfbqJX/XQ4+tGSHCC7rE6D/Q+j
f/kAoJpdva3ylipMmDF45jIsmqC8TTR+
=ZlaQ
-----END PGP SIGNATURE-----



In response to

Responses

pgsql-interfaces by date

Next:From: Greg StarkDate: 2009-11-14 18:48:29
Subject: Re: Upgrading databases
Previous:From: Bosco RamaDate: 2009-11-11 18:58:43
Subject: Re: Upgrading databases

pgsql-general by date

Next:From: Tom LaneDate: 2009-11-14 16:22:21
Subject: Re: Voting: "pg_ctl init" versus "initdb"
Previous:From: Zdenek KotalaDate: 2009-11-14 14:07:45
Subject: Voting: "pg_ctl init" versus "initdb"

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