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 260963A5A13 for ; Fri, 3 Dec 2004 02:50:09 +0000 (GMT) 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 07595-10 for ; Fri, 3 Dec 2004 02:50:02 +0000 (GMT) Received: from floppy.pyrenet.fr (floppy.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id 02BDF3A5A0E for ; Fri, 3 Dec 2004 02:50:05 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 6A4E231919; Fri, 3 Dec 2004 03:50:06 +0100 (MET) From: Christopher Browne X-Newsgroups: pgsql.performance Subject: Re: pg replication tools? Date: Thu, 02 Dec 2004 21:39:02 -0500 Organization: cbbrowne Computing Inc Lines: 32 Message-ID: References: <20041202143816.14226.qmail@web51305.mail.yahoo.com> <41AF47BB.20903@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:oK/z6j575SLYggUv1R2iQv61CNc= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/77 X-Sequence-Number: 9452 Clinging to sanity, jd@commandprompt.com ("Joshua D. Drake") mumbled into her beard: > sarlav kumar wrote: > >> Hi all, >> Which is the best available PG replication tool in market now? > > There is no "best", there is only best for your situation. The two > most supported are: > > >> * Mammoth PostgreSQL Replicator * Slony-I >> >> Which one of these is a good option for replicating Postgres 7.3.2? >> > > Mammoth PostgreSQL Replicator will automatically upgrade you to > 7.3.8 which you should be running anyway. > > I believe Slony will work with 7.3.2. No, it won't. I believe there was something about namespace support that did not stabilize until PostgreSQL 7.3.3, and Slony-I works with that version, at the earliest. And you're quite right; "best" is a slippery metric. Like many things, it may be altered by perspective. -- If this was helpful, rate me http://www3.sympatico.ca/cbbrowne/postgresql.html I can see clearly now, the brain is gone...