X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 24B3753649 for ; Wed, 30 Mar 2005 01:16:42 +0100 (BST) 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 41951-06 for ; Wed, 30 Mar 2005 00:16:38 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 9C2AA5368B for ; Wed, 30 Mar 2005 01:16:38 +0100 (BST) Received: from 192.168.1.52 (fc1smp [66.93.38.87]) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j2U0DFkh021353; Tue, 29 Mar 2005 16:13:15 -0800 Subject: Re: Replication solutions high volume db From: "Joshua D. Drake" Reply-To: jd@commandprompt.com To: Scott Marlowe Cc: David B , pgsql-admin@postgresql.org In-Reply-To: <1112141567.31277.33.camel@state.g2switchworks.com> References: <1112140257.27795.67.camel@jd2.commandprompt.com> <1112141567.31277.33.camel@state.g2switchworks.com> Content-Type: text/plain Organization: Joshua D. Drake Date: Tue, 29 Mar 2005 16:16:37 -0800 Message-Id: <1112141797.27795.74.camel@jd2.commandprompt.com> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 (2.0.2-3) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.032 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/472 X-Sequence-Number: 16970 On Tue, 2005-03-29 at 18:12 -0600, Scott Marlowe wrote: > On Tue, 2005-03-29 at 17:50, Joshua D. Drake wrote: > > > > > > I think I've narrowed it down to Slony and Mammoth. > > > Any pro's or con's on one vs the other? > > > > Slony is more complicated to setup. > > Slony requires triggers and cron. > > Triggers yes, cron no... Oh? Good to know. > > > It used to be that Slony was timed replication. I do not know if that is > > still the case. > > Not the case now. I didn't use it "back in the day" (you know, last > year :) I know.. that is so 2004 :) Sincerely, Joshua D. Drake > -- Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564 Custom programming, 24x7 support, managed services, and hosting Open Source Authors: plPHP, pgManage, Co-Authors: plPerlNG Reliable replication, Mammoth Replicator - http://www.commandprompt.com/