On Mon, Jul 13, 2009 at 4:20 PM, Kenneth Marshall<ktm at rice.edu> wrote:
> On Mon, Jul 13, 2009 at 02:23:05PM -0700, David Rees wrote:
>> On Mon, Jul 13, 2009 at 1:59 PM, Kenneth Marshall<ktm at rice.edu> wrote:
>> > In particular, I would like to be able to upgrade an
>> > 8.3 databae to 8.4 with minimal downtime. 1.2.14 does
>> > not build with a missing function definition for
>> > SerializableSnapshot. If not, is there a scheme to
>> > upgrade to 8.4 that does not entail the outage of
>> > a full dump/restore cycle?
>>
>> Did you try the latest version (1.2.16) of slony first?
>
> No, because our version of 8.3.x is compiled against 1.2.14
> and if 8.4 will work with that then I do not have to re-build
> and test 8.3.x with a newer version of Slony and then handle
> the change control process for upgrading to the new version
> of Slony on the 8.3 server. Then replicate to 8.4, followed
> by change control to make it the master, followed by another
> round of rebuilding 8.4 with Slony 2.x, and more change
> control to manage the upgrade to 2.x. If 1.2.14 will work
> I avoid a whole lot of testing and change management.

Well, it's quite clear that 1.2.14 won't work without at least
applying some patches to it.

I found this thread regarding 1.2.15 which has the same problem.  The
compilation problem isn't fixed until 1.2.16.

http://www.nabble.com/Compilation-of-Slony-1.2.15-with-PostgreSQL-8.4-beta-1---td23218178.html

-Dave