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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-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

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-11-14 16:22:21 Re: Voting: "pg_ctl init" versus "initdb"
Previous Message Zdenek Kotala 2009-11-14 14:07:45 Voting: "pg_ctl init" versus "initdb"

Browse pgsql-interfaces by date

  From Date Subject
Next Message Greg Stark 2009-11-14 18:48:29 Re: Upgrading databases
Previous Message Bosco Rama 2009-11-11 18:58:43 Re: Upgrading databases