By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,834 Members | 2,265 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,834 IT Pros & Developers. It's quick & easy.

Replication ?

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.