Re: Replication - Mailing list pgsql-general

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