Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 45E4A9FB2D6; Tue, 24 Oct 2006 19:15:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 35753-04; Tue, 24 Oct 2006 19:15:04 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from edb06.mail01.enterprisedb.com (63-246-7-171.contegix.com [63.246.7.171]) by postgresql.org (Postfix) with ESMTP id 60BC19FB2BD; Tue, 24 Oct 2006 19:15:04 -0300 (ADT) thread-index: Acb3udrxjyRpu7O3RJ+fmVCGAZ7lmA== Received: from [192.168.0.31] ([84.12.199.61]) by edb06.mail01.enterprisedb.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 24 Oct 2006 18:15:03 -0400 Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2757 Subject: Re: Replication documentation addition From: "Simon Riggs" To: "Bruce Momjian" Cc: "PostgreSQL-documentation" , "PostgreSQL-development" In-Reply-To: <200610240420.k9O4Keq23589@momjian.us> References: <200610240420.k9O4Keq23589@momjian.us> Content-Type: text/plain; charset="iso-8859-1" Date: Tue, 24 Oct 2006 23:14:41 +0100 Message-ID: <1161728082.3861.330.camel@silverbirch.site> MIME-Version: 1.0 X-Mailer: Evolution 2.6.0 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 24 Oct 2006 22:15:04.0046 (UTC) FILETIME=[DAEAA8E0:01C6F7B9] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.86 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO, SARE_SPEC_REPLICA X-Spam-Level: * X-Archive-Number: 200610/53 X-Sequence-Number: 3774 On Tue, 2006-10-24 at 00:20 -0400, Bruce Momjian wrote: > Here is a new replication documentation section I want to add for 8.2: > > ftp://momjian.us/pub/postgresql/mypatches/replication > > Comments welcomed. It's a very good start to a complete minefield of competing solutions. My first thought would be to differentiate between clustering and replication, which will bring out many differences. My second thought would be to differentiate between load balancing, multi-threading, parallel query, high availability and recoverability, which would probably sort out the true differences in the above mix. But that wouldn't help most people and almost everybody would find fault. IMHO most people I've spoken to take "replication" to mean an HA solution, so perhaps we should cover it in those terms. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com