From: John Sidney-Woollett <johnsw@wardbrook.com>
To: Andrew Rawnsley <ronz@ravensfield.com>
Cc: pgsql-general@postgresql.org
Subject: Re: Replication
Date: Thu, 18 Dec 2003 08:16:59 -0000 (GMT)
Message-ID: <3295.192.168.0.64.1071735419.squirrel@mercury.wardbrook.com> (raw)
In-Reply-To: <6EE299B8-309C-11D8-89B5-000393A47FCC@ravensfield.com>
References: <3FDFAD8F.5080404@digitalflex.net>
<1294.192.168.0.64.1071647844.squirrel@mercury.wardbrook.com>
<1319.192.168.0.64.1071648485.squirrel@mercury.wardbrook.com>
<1339.192.168.0.64.1071648904.squirrel@mercury.wardbrook.com>
<6EE299B8-309C-11D8-89B5-000393A47FCC@ravensfield.com>
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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: johnsw@wardbrook.com, ronz@ravensfield.com
Subject: Re: Replication
In-Reply-To: <3295.192.168.0.64.1071735419.squirrel@mercury.wardbrook.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox