X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 56BDBD1B53E for ; Thu, 18 Dec 2003 20:41:43 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 80438-06 for ; Thu, 18 Dec 2003 16:40:55 -0400 (AST) Received: from bramble.mmrd.com (unknown [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id D9A33D1B4C3 for ; Thu, 18 Dec 2003 16:40:52 -0400 (AST) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id hBIJs7cM013090; Thu, 18 Dec 2003 14:54:07 -0500 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id hBIKejl12400; Thu, 18 Dec 2003 15:40:45 -0500 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id XT877RAV; Thu, 18 Dec 2003 15:40:42 -0500 Subject: Re: Replication From: Robert Treat To: johnsw@wardbrook.com Cc: Anthony Best , "pgsql-general@postgresql.org" In-Reply-To: <1339.192.168.0.64.1071648904.squirrel@mercury.wardbrook.com> References: <3FDFAD8F.5080404@digitalflex.net> <1294.192.168.0.64.1071647844.squirrel@mercury.wardbrook.com> <1319.192.168.0.64.1071648485.squirrel@mercury.wardbrook.com> <1339.192.168.0.64.1071648904.squirrel@mercury.wardbrook.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 18 Dec 2003 15:40:44 -0500 Message-Id: <1071780044.1792.9028.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/1030 X-Sequence-Number: 54423 Check out the pg_replicator project on gborg, IIRC it has links to some of the replication solutions.... USOGRES comes to mind... BTW - I'f you do give each one a twirl, we'd love to hear about your experiences. Robert Treat On Wed, 2003-12-17 at 03:15, John Sidney-Woollett wrote: > Apologies if this is a double post - I'm sure I sent a similar e-mail to > the list, but it seems to have disappeared in the ether. > > Id there a definitive list of what replication options are currently > available for 7.4 (and 7.5), and what their relative strengths and > weaknesses are; ease of use, configuration, cost, support etc > > I need to start tackling replication of our DB in the next few weeks, and > wondered what the options are. > > I've seen RServer and Mammoth Replication - these look good (on paper) but > both appear to involve a license fee (which is more than I have to spend > right now). > > Is pgReplication ready for 7.4 yet? And are there any other *free* > options? If not maybe I'll have to find the money for a commercial > solution. > > I'd appreciate any feedback from anyone who has a working replication > solution. > > Thanks > > John Sidney-Woollett > > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL