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-general(at)postgresql(dot)org,markmapo(at)yahoo(dot)com
Subject: Re: Upgrading databases
Date: 2009-11-14 22:42:25
Message-ID: 7b3770989ea41081535932fee8440d7c@biglumber.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
-----BEGIN PGP SIGNED MESSAGE-----                                           
Hash: RIPEMD160                                                              


Greg quoting Greg asks:

>> 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.                   

> I've never done this process myself. I'm wondering how flexible Slony
> and Bucardo are with the versions of Postgres they support.          
>                                                                      
> Does the Slony version run on the new version have to match the Slony
> version on the old one? Do old versions of Slony work on new versions
> of Postgres? Or do you have to update the version of Slony on the old
> database before you can move to a new database version because the new
> database version requires a newer version of Slony?

ObNote: Interfaces is not really the correct mailing list for this, so I'm
cc'ing it over to pgsql-general.

Yes, Slony must be the same. Older versions of Slony will not work against
new versions of Postgres (nor will newer versions of Slony work against
older versions of Postgres).

> I'm even less familiar with Bucardo but have the same questions there too.

Bucardo can connect to any Postgres 8.1 or greater. It may even work against
older versions, but nobody has tested with versions that old that I know of.
The source and target can be different versions of Postgres, no problem.
Unlike Slony, there is only a single master Bucardo daemon that can live
anywhere, even a box that is not the master or slave, as long as it can
talk to both.

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

iEYEAREDAAYFAkr/MiEACgkQvJuQZxSWSsgGcQCfVCr0jIciY5b9N4OljPn61cMo
BoEAn03wsZ5EDrqZ2WRZIOPsAa/nXsk0
=L94s
-----END PGP SIGNATURE-----



In response to

pgsql-interfaces by date

Next:From: Raimon FernandezDate: 2009-11-19 16:05:35
Subject: Encoding using the Frontend/Backend Protocol TCP/IP
Previous:From: Mark RichardsonDate: 2009-11-14 19:20:05
Subject: Re: Upgrading databases

pgsql-general by date

Next:From: Thom BrownDate: 2009-11-14 22:51:03
Subject: Re: pgday.eu
Previous:From: John R PierceDate: 2009-11-14 22:08:23
Subject: Re: Fast Search on Encrypted Feild

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