Message-ID: <3295.192.168.0.64.1071735419.squirrel@mercury.wardbrook.com>
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>
Date: Thu, 18 Dec 2003 08:16:59 -0000 (GMT)
Subject: Re: Replication
From: "John Sidney-Woollett" <johnsw@wardbrook.com>
To: "Andrew Rawnsley" <ronz@ravensfield.com>
Cc: pgsql-general@postgresql.org
Reply-To: johnsw@wardbrook.com
User-Agent: SquirrelMail/1.4.2 [CVS]
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Importance: Normal

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
>
>