-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Le 10/09/2012 19:54, Vick Khera a écrit :
> On Mon, Sep 10, 2012 at 1:26 PM, "Stéphane A. Schildknecht" 
> <stephane.schildknecht at postgresql.fr 
> <mailto:stephane.schildknecht at postgresql.fr>> wrote:
> 
> I wondered if there was a magic plan I could rely on to ease my multiple 
> node replication cluster.
> 
> As there isn't any magical plan, I will have to consider in more deep 
> details the idea of a  two phase migration, as proposed by Christopher.
> 
> 
> I think the magic would be "go back in time and do not wait so long 
> between major version upgrades."

That is the key point.
I won't try to explain that I was no decision-maker in that story.

> 
> It certainly will be safest to do the multi-step upgrade.  I'd guess you 
> don't need to do multiple steps for every node in your cluster depending 
> on how they are used...

Not every one of them, but surely more than one.

S.

PS : To be complete, I join the error I got when trying to compile Slony 1.2
with PG 9.2 :
slony1_funcs.c: In function ?_Slony_I_logTrigger?:
slony1_funcs.c:515:38: error: dereferencing pointer to incomplete type
...
- -- 
Stéphane Schildknecht
http://www.Loxodata.com
Contact régional PostgreSQL

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://www.enigmail.net/

iEYEARECAAYFAlBOSWkACgkQA+REPKWGI0Hd5wCeOosDZK7dhR3FNedasyeMaGBv
/ksAoJSLsGFra9SUXT0J4iFUbW8bYfpf
=cOEp
-----END PGP SIGNATURE-----