Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 74C449FB266; Thu, 26 Oct 2006 12:55:51 -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 15213-09; Thu, 26 Oct 2006 12:55:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 36BE69F9F7F; Thu, 26 Oct 2006 12:55:40 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 0A5C25643A; Thu, 26 Oct 2006 10:55:40 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Thu, 26 Oct 2006 10:55:36 -0500 Date: Thu, 26 Oct 2006 10:55:36 -0500 From: "Jim C. Nasby" To: Bruce Momjian Cc: Dawid Kuroczko , pgsql-docs@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Replication documentation addition Message-ID: <20061026155535.GU26892@nasby.net> References: <20061025234953.GB26892@nasby.net> <200610260042.k9Q0g7a03961@momjian.us> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="CE+1k2dSO48ffgeK" Content-Disposition: inline In-Reply-To: <200610260042.k9Q0g7a03961@momjian.us> X-Operating-System: FreeBSD 6.1-RELEASE-p10 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.13 (2006-08-11) X-Hashcash: 1:20:061026:bruce@momjian.us::qldV1UJ9ApI8SfEX:00sMt X-Hashcash: 1:20:061026:qnex42@gmail.com::yKW++jD4vsaUoWde:04LIw X-Hashcash: 1:20:061026:pgsql-docs@postgresql.org::gBYodI3vSeFo7VM+:000000000000 0000000000000000000000000GEY X-Hashcash: 1:20:061026:pgsql-hackers@postgresql.org::jVDLKYontBj+uCyr:000000000 00000000000000000000000005nG X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.437 tagged_above=0 required=5 tests=AWL, SARE_SPEC_REPLICA X-Spam-Level: X-Archive-Number: 200610/108 X-Sequence-Number: 3829 --CE+1k2dSO48ffgeK Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Oct 25, 2006 at 08:42:07PM -0400, Bruce Momjian wrote: > Jim C. Nasby wrote: > > Something else worth doing though is to have a paragraph explaining why > > there's no built-in replication. I don't have time to write something > > right now, but I can do it later tonight if no one beats me to it. > > I thought that was implied in the early paragraph about why there are > many solutions. I think we should explicitely spell it out, especially considering how many times people ask about it. How about... This multitude of choices is why PostgreSQL does not ship with a replication solution by default; any bundled solution would only satisfy a subset of replication needs. (sorry for the non-standard patch, but anoncvs isn't sync'd up yet). -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) --CE+1k2dSO48ffgeK Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename=patch *** failover.sgml.org Thu Oct 26 10:32:45 2006 --- failover.sgml Thu Oct 26 10:55:03 2006 *************** *** 29,35 **** working together. Because there is no single solution that eliminates the impact of the sync problem for all use cases, there are multiple solutions. Each solution addresses this problem in a different way, and ! minimizes its impact for a specific workload. --- 29,37 ---- working together. Because there is no single solution that eliminates the impact of the sync problem for all use cases, there are multiple solutions. Each solution addresses this problem in a different way, and ! minimizes its impact for a specific workload. This multitude of choices is ! why PostgreSQL does not ship with a replication solution by default; any ! bundled solution would only satisfy a subset of replication needs. --CE+1k2dSO48ffgeK--