Has used any of the PostgreSQL replication software? In a production
environment? I need to create an environment where there are two
DBMBS servers with identical datamodels which both receive a steady
stream of inserts and I need the information inserted into each
server to be replicated on the other. There is no chance of
collisions - duplicate or conflicted data being inserted. The gotcha
is that they are in an envrironment where they will have network
activity, but it is guaranteed to be intermittant (it will probably
be down 10% of the time, its a high bandwidth wireless link).
<p>
There are a list of the various projects <a
href=
http://techdocs.postgresql.org/oresources.php>here</a>. This is
my take on them from looking at the project pages. If anyone has any
expereience with them, I'd really appreciate hearing about it.
<p>
<i>eRServer (PostgreSQL Enterprise Replication Server):</i> Looks
like this hasn't been updated in a very long time.
<p>
<i>PostgreSQL Replicator by Matteo Cavalleri, Rocco Prudentino, and
the IRCCS Medea Bioengineering Lab:</i> This one looks the more
promising, it seems to be active and people seem to be using it.
<p>
<i>Usogres by Tetsuichi Hosokawa:</i> Seems to be actively developed
but hasn't hit 1.0 yet.
<p>
<i>PostgreSQL Replication Resources on gborg.postgresql.org:</i>
This looks like the official effort, but its based on PostgreSQL
version 6.5, and I'd really prefer to use a more recent version.
<p>
<i>DBBalancer by Daniel Varela Load Balancing, Connection Pooling,
and Replication software:</i> Still in alpha and hasn't been update
for over a year.
