On Fri, Oct 28, 2011 at 1:20 PM, Matthias Leopold <matthias at aic.at> wrote:
> hi,
>
> i'm running a slony 1.2.21 cluster. the master postgres server has
> postgres version 8.3.9 on i386 architecture. slave nodes mostly have
> postgres 8.3.x, one has 8.4.x
>
> would it be possible to do the following:
>
> - stop write access to master server
>
> - stop all slons
>
> - pg_dump master database
>
> - shut old physical master server down
>
> - load the dump in a 8.4 postgres server with slony 1.2.21 on x86_64
> architecture with same network address as old physical master
>
> - start slons again
>
> - enable write access to new physical master and continue with replication

Wait what are you trying to do?  Make the 8.4 machine the master?
Just initiate a slony switchover and it will be the master.  More
detail on what you're trying to accomplish, not on how you're trying
to accomplish it might help here.