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 93593D1B46C for ; Wed, 17 Dec 2003 08:16:57 +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 86972-07 for ; Wed, 17 Dec 2003 04:16:28 -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 8A21ED1C9D7 for ; Wed, 17 Dec 2003 04:16:26 -0400 (AST) Received: from localhost (mercury.wardbrook.com [127.0.0.1]) by mercury.wardbrook.com (Postfix) with ESMTP id 6E9A0532EB; Wed, 17 Dec 2003 08:15:08 +0000 (GMT) Received: by mercury.wardbrook.com (Postfix, from userid 505) id 6E10D532ED; Wed, 17 Dec 2003 08:15:06 +0000 (GMT) Received: from 192.168.1.219 (mercury.wardbrook.com [127.0.0.1]) by mercury.wardbrook.com (Postfix) with SMTP id C4A0B532EB; Wed, 17 Dec 2003 08:15:04 +0000 (GMT) Received: from 192.168.0.64 (SquirrelMail authenticated user johnsw) by mercury.wardbrook.com with HTTP; Wed, 17 Dec 2003 08:15:04 -0000 (GMT) Message-ID: <1339.192.168.0.64.1071648904.squirrel@mercury.wardbrook.com> In-Reply-To: <1319.192.168.0.64.1071648485.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> Date: Wed, 17 Dec 2003 08:15:04 -0000 (GMT) Subject: Replication From: "John Sidney-Woollett" To: johnsw@wardbrook.com 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/935 X-Sequence-Number: 54328 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