Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 7AC85633F7B
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun,  5 Apr 2009 15:36:25 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 95219-07
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun,  5 Apr 2009 15:36:22 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mx1.ctgameinfo.com (eureka.ctgameinfo.com [67.228.20.98])
	by mail.postgresql.org (Postfix) with ESMTP id 4CDE9630733
	for <pgsql-performance@postgresql.org>;
	Sun,  5 Apr 2009 15:36:22 -0300 (ADT)
Received: from [192.168.1.103] (S01060016b606ed02.vc.shawcable.net
	[24.84.173.161])
	by mx1.ctgameinfo.com (Postfix) with ESMTP id 7622F5643F
	for <pgsql-performance@postgresql.org>;
	Sun,  5 Apr 2009 11:36:20 -0700 (PDT)
Message-ID: <49D8FA31.8010407@on-track.ca>
Date: Sun, 05 Apr 2009 11:36:33 -0700
From: Lists <lists@on-track.ca>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Best replication solution?
Content-Type: multipart/alternative;
	boundary="------------030001040307050106080703"
X-Virus-Scanned: ClamAV 0.94.2/9205/Sat Apr 4 20:09:43 2009 on
	eureka.ctgameinfo.com
X-Virus-Status: Clean
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.9 tagged_above=0 required=5 tests=FS_REPLICA=1.179,
	HTML_MESSAGE=0.001, SARE_SPEC_REPLICA=0.72
X-Spam-Level: *
X-Archive-Number: 200904/107
X-Sequence-Number: 33474

This is a multi-part message in MIME format.
--------------030001040307050106080703
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I am looking to setup replication of my postgresql database, primarily 
for performance reasons.

The searching I've done shows a lot of different options, can anyone 
give suggestions about which one(s) are best? I've read the archives, 
but there seems to be more replication solutions since the last thread 
on this subject and it seems to change frequently.

I'd really like a solution that replicates DDL, but very few do so I 
think I'm out of luck for that. I can live without it.
Multi-master support would be nice too, but also seems to cause too many 
problems so it looks like I'll have to do without it too.


*Slony-I* - I've used this in the past, but it's a huge pain to work 
with, caused serious performance issues under heavy load due to long 
running transactions (may not be the case anymore, it's been a while 
since I used it on a large database with many writes), and doesn't seem 
very reliable (I've had replication break on me multiple times).

*Mammoth Replicator* - This is open source now, is it any good? It 
sounds like it's trigger based like Slony. Is it based on Slony, or 
simply use a similar solution?

*pgpool* - Won't work for us reliably for replication because we have 
some triggers and stored procedures that write data.

*PGCluster* - Sounds cool, but based on the mailing list traffic and the 
last news post on the site being from 2005, development seems to be near 
dead. Also, no releases seems to make it beyond the RC stage -- for 
multi-master stability is particularly important for data integrity.

*PGReplicator - *Don't know anything special about it.
*
Bucardo* - Don't know anything special about it.

*Postgres-R* - Don't know anything special about it.

*SkyTools/Londiste* - Don't know anything special about it.

--------------030001040307050106080703
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
I am looking to setup replication of my postgresql database, primarily
for performance reasons.<br>
<br>
The searching I've done shows a lot of different options, can anyone
give suggestions about which one(s) are best? I've read the archives,
but there seems to be more replication solutions since the last thread
on this subject and it seems to change frequently. <br>
<br>
I'd really like a solution that replicates DDL, but very few do so I
think I'm out of luck for that. I can live without it. <br>
Multi-master support would be nice too, but also seems to cause too
many problems so it looks like I'll have to do without it too. <br>
<br>
<br>
<b>Slony-I</b> - I've used this in the past, but it's a huge pain to
work with, caused serious performance issues under heavy load due to
long running transactions (may not be the case anymore, it's been a
while since I used it on a large database with many writes), and
doesn't seem very reliable (I've had replication break on me multiple
times).<br>
<br>
<b>Mammoth Replicator</b> - This is open source now, is it any good? It
sounds like it's trigger based like Slony. Is it based on Slony, or
simply use a similar solution?<br>
<br>
<b>pgpool</b> - Won't work for us reliably for replication because we
have some triggers and stored procedures that write data.<br>
<br>
<b>PGCluster</b> - Sounds cool, but based on the mailing list traffic
and the last news post on the site being from 2005, development seems
to be near dead. Also, no releases seems to make it beyond the RC stage
-- for multi-master stability is particularly important for data
integrity.<br>
<br>
<b>PGReplicator - </b>Don't know anything special about it.<br>
<b><br>
Bucardo</b> - Don't know anything special about it.<br>
<br>
<b>Postgres-R</b> - Don't know anything special about it.<br>
<br>
<b>SkyTools/Londiste</b> - Don't know anything special about it.
</body>
</html>

--------------030001040307050106080703--