Replication ?

[Andreas]

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

[John Sidney-Woollett]

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.
[phone]
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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly