Re: Replication

Andrew

Thanks for the info.

Can you detail more fully the changes you made to eRServer - v1.2, and
will your patched version work with 7.4?

John

Andrew Rawnsley said:
>
> On Dec 17, 2003, at 3:15 AM, John Sidney-Woollett wrote:
>
>> Apologies if this is a double post - I'm sure I sent a similar e-mail
>> to
>> the list, but it seems to have disappeared in the ether.
>>
>> Id there a definitive list of what replication options are currently
>> available for 7.4 (and 7.5), and what their relative strengths and
>> weaknesses are; ease of use, configuration, cost, support etc
>>
>> I need to start tackling replication of our DB in the next few weeks,
>> and
>> wondered what the options are.
>>
>> I've seen RServer and Mammoth Replication - these look good (on paper)
>> but
>> both appear to involve a license fee (which is more than I have to
>> spend
>> right now).
>
> There's 2 versions of eRServer - v1.2 is free on gborg and Postgresql,
> Inc. has another
> that you get with a support contract.
>
> I've patched eRServer pretty heavily to fix some bugs and add some
> usability. The
> eRServer list has some discussion of these.
>
> Jan Weick is in the early stages of developing a new replication system
> that
> looks to be pretty nice.  He also has a project set up on gborg.
>
> In addition, RServ (what eRServer was based on) is still going, along
> with dbmirror
> (which is in contrib in the main distribution).
>
> Mammoth is something you would have to ask Joshua Drake about. Don't
> know anything about it.
>
>>
>> Is pgReplication ready for 7.4 yet? And are there any other *free*
>> options? If not maybe I'll have to find the money for a commercial
>> solution.
>
> Doesn't look like based on the web site at gborg.
>
>>
>> I'd appreciate any feedback from anyone who has a working replication
>> solution.
>>
>
> So far eRServer is working ok for me. If you use the unpatched version
> on gborg, be sure to
> read the erserver list archives, as the current tarball has a problem
> or two. If you want to
> work with my fork let me know. I like to think it works better, but I'm
> hardly unbiased...
>
>> Thanks
>>
>> John Sidney-Woollett
>>
>>
>>
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 9: the planner will ignore your desire to choose an index scan if
>> your
>>       joining column's datatypes do not match
>>
> --------------------
>
> Andrew Rawnsley
> President
> The Ravensfield Digital Resource Group, Ltd.
> (740) 587-0114
> www.ravensfield.com
>
>