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 455D0D1B4C6 for ; Thu, 18 Dec 2003 21:38:38 +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 88235-07 for ; Thu, 18 Dec 2003 17:37:51 -0400 (AST) Received: from mercury.wardbrook.com (217.79.104.122.adsl.griffin.net.uk [217.79.104.122]) by svr1.postgresql.org (Postfix) with ESMTP id 8576AD1B43F for ; Thu, 18 Dec 2003 17:37:48 -0400 (AST) Received: from localhost (mercury.wardbrook.com [127.0.0.1]) by mercury.wardbrook.com (Postfix) with ESMTP id 8307B532EB; Thu, 18 Dec 2003 21:35:55 +0000 (GMT) Received: by mercury.wardbrook.com (Postfix, from userid 505) id B71B3532ED; Thu, 18 Dec 2003 21:35:53 +0000 (GMT) Received: from 192.168.1.219 (mercury.wardbrook.com [127.0.0.1]) by mercury.wardbrook.com (Postfix) with SMTP id 19284532EB; Thu, 18 Dec 2003 21:35:52 +0000 (GMT) Received: from 192.168.0.64 (SquirrelMail authenticated user johnsw) by mercury.wardbrook.com with HTTP; Thu, 18 Dec 2003 21:35:52 -0000 (GMT) Message-ID: <1885.192.168.0.64.1071783352.squirrel@mercury.wardbrook.com> In-Reply-To: <1071780044.1792.9028.camel@camel> 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> <1071780044.1792.9028.camel@camel> Date: Thu, 18 Dec 2003 21:35:52 -0000 (GMT) Subject: Re: Replication From: "John Sidney-Woollett" To: "Robert Treat" Cc: johnsw@wardbrook.com, "Anthony Best" , "pgsql-general@postgresql.org" Reply-To: johnsw@wardbrook.com User-Agent: SquirrelMail/1.4.2 [CVS] MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 Importance: Normal X-Virus-Scanned: by AMaViS 0.3.12 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/1037 X-Sequence-Number: 54430 Robert Thanks for the info. I'll keep the list posted with feedback after I decide which product to go with. John Robert Treat said: > 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 > >