X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4C78A5E37CB for ; Fri, 13 Aug 2004 22:27:26 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44706-09 for ; Sat, 14 Aug 2004 01:27:18 +0000 (GMT) Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.207]) by svr1.postgresql.org (Postfix) with ESMTP id 934125E3639 for ; Fri, 13 Aug 2004 22:27:11 -0300 (ADT) Received: by mproxy.gmail.com with SMTP id 76so31740rnl for ; Fri, 13 Aug 2004 18:27:04 -0700 (PDT) Received: by 10.38.70.74 with SMTP id s74mr186332rna; Fri, 13 Aug 2004 18:27:04 -0700 (PDT) Message-ID: Date: Fri, 13 Aug 2004 18:27:04 -0700 From: Chris Cheston To: pgsql-performance@postgresql.org Subject: Replication: Slony-I vs. Mammoth Replicator vs. ? Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/223 X-Sequence-Number: 7859 HI all, I'm trying to implement a highly-scalable, high-performance, real-time database replication system to back-up my Postgres database as data gets written. So far, Mammoth Replicator is looking pretty good but it costs $1000+ . Has anyone tried Slony-I and other replication systems? Slony-I is pretty new so I'm a little unsure if it's ready for a prime-time commercial system yet. So... wanted to put this out to the experts. Has anyone got any recommendations or had experiences with real-time database replication solutions that don't rely on RAID? The reason why I don't want to rely on a hardware solution is because we are renting dedicated servers and we don't have access to the boxes, only to software that gets installed on the boxes. Thanks, Chris