Re: Replication ? - Mailing list pgsql-general

Here is some info (see below).

Andrew Rawnsley gave some quite good feedback, and an offer of his
modified version eRServer - try checking the archives for more info, or
e-mail me in about 4 weeks time when I will have installed (hopefully) a
replication solution.

John Sidney-Woollett

> 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

Andreas said:
> Hello list,
>
> did someone try successfully to use the replication extension that was
> released to the community this summer ?
>
> Maybe someone could share his/her impressions and produce a tiny
> description what to do to actually build the extension, install and
> connect 2 servers so they share the sql that is thrown at them.
>
>
> Watch your way when you step over into 2004 later today   ;)
>
> Andreas
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>