Re: Re: Moving a live production database to different server and postgres release

OK,

I see. Does this mean I need to install Slony-I 1.x on both systems or
is different versions of Slony-I, say a 2.x and a 1.x, compatible? The
reason I'm asking is because the new server db will be part of a
permanent postgres replication system in the future and installing a
newer verision of Slony-I would spare me some future work.

/Regards

On Mon, Jun 14, 2010 at 3:15 PM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
> On 14/06/2010 14:09, Ulas Albayrak wrote:
>
>> After your post I had a look at Slony-I, which, according to it web
>> page, requires postgres 8.3 or later, so I guess that won't work. That
>> leaves Bucardo: will it work on a Windows system?
>
> AIUI, the Slony-I 2.x branch requires PG 8.3+, but the 1.x branch ill
> work perfectly fine on 8.2 and lower.
>
> This is because 1.x messes with the system catalogues and strange ways,
> whereas changes in PG 8.3 made this unnecessary.
>
> HTH,
>
> Ray.
>
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> rod(at)iol(dot)ie
>

--
Ulas Albayrak
ulas(dot)albayrak(at)gmail(dot)com