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 160E35E3F15 for ; Sat, 14 Aug 2004 18:11:55 -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 86462-03 for ; Sat, 14 Aug 2004 21:11:52 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id D4CC25E37D0 for ; Sat, 14 Aug 2004 18:11:50 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i7ELBniG087324 for ; Sat, 14 Aug 2004 21:11:49 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i7EKnvWJ083309 for pgsql-performance@postgresql.org; Sat, 14 Aug 2004 20:49:57 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Replication: Slony-I vs. Mammoth Replicator vs. ? Date: Sat, 14 Aug 2004 15:58:18 -0400 Organization: cbbrowne Computing Inc Lines: 26 Message-ID: References: <411D6D47.5020203@commandprompt.com> <411E30C4.8020909@Yahoo.com> <411E3C3B.5060808@commandprompt.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Security Through Obscurity, linux) Cancel-Lock: sha1:0CybtXmfdGTGyDIuvt/yfPEBtWM= To: pgsql-performance@postgresql.org 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/232 X-Sequence-Number: 7868 Centuries ago, Nostradamus foresaw when jd@commandprompt.com ("Joshua D. Drake") would write: > I hope you understand that I, in no way have ever suggested > (purposely) anything negative about Slony. Only that I believe they > serve different technical solutions. Stipulating that I may have some bias ;-), I still don't find it at all clear what the different situations are "shaped like" that lead to Mammoth being forcibly preferable to Slony-I. (Note that I have a pretty decent understanding about how ERS and Slony work, so I'm not too frightened of technicalities... I set up instances of both on Thursday, so I'm pretty up to speed :-).) Win32 support may be true at the moment, although I have to discount that as we only just got the start of a beta release of native Win32 support for PostgreSQL proper. For that very reason, I had to point my youngest brother who needed "something better than Access" to Firebird last Saturday; I played with my niece while he was doing the install. And there is little reason to think that Slony-I won't be portable to Win32 given a little interest and effort, particularly once work to make it play well with "pgxs" gets done. -- (format nil "~S@~S" "cbbrowne" "ntlug.org") http://www3.sympatico.ca/cbbrowne/multiplexor.html "At Microsoft, it doesn't matter which file you're compiling, only which flags you #define." -- Colin Plumb