On 09/06/2012 03:58 AM, "Stéphane A. Schildknecht" wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hello,
>
> I currently have a 1.2 slony cluster replicating PostgreSQL 8.2 databases.
>
> On our way to migrate to PostgreSQL 9.2, we would like to use Slony to ease
> the migration process.
>
> But, I wonder which version of Slony I could use, as the version currently
> used won't compile vs PostgreSQL 9.2rc1. Neither would slony 2.1.2 compile
> with PG 8.2.
>
> Thanks in advance for any advice.

You won't be able to get slony 2.0.x or 2.1.x to work with 8.2.    I 
suspect it won't be that hard to get 1.2 to compile against 9.2, the 
patches to get 2.1.x compiling against 9.2 were not that involved.  It 
won't work well because of the serialization conflicts that slony prior 
to 2.1.1 gets with PG 9.1+ but it might work well enough for an 
upgrade.  (I also can't say if there are any other issues with running 
1.2 against 9.2 since I've never tried it).

Your other option is, as Chris mentioned, to upgrade in two steps.

Steve

> Regards,
> - -- 
> 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/
>
> iEYEARECAAYFAlBIV78ACgkQA+REPKWGI0E/uACglepw4b1o+Wq79gUxVA75yqbO
> il8An2fynXRvQaBMoVH9JvFZo8nK/OJH
> =S8Sm
> -----END PGP SIGNATURE-----
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>
>