Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 511DF9FA4C5; Thu, 26 Oct 2006 15:28:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 92235-06; Thu, 26 Oct 2006 18:27:40 +0000 (UTC) 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 8699B9FB225; Thu, 26 Oct 2006 15:27:39 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 5EA3456408; Thu, 26 Oct 2006 13:27:38 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Thu, 26 Oct 2006 13:27:34 -0500 Date: Thu, 26 Oct 2006 13:27:33 -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: <20061026182733.GV26892@nasby.net> References: <20061026155535.GU26892@nasby.net> <200610261559.k9QFxv129610@momjian.us> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="XF85m9dhOBO43t/C" Content-Disposition: inline In-Reply-To: <200610261559.k9QFxv129610@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::wTXoLK0xjGNa0AdD:02iLp X-Hashcash: 1:20:061026:qnex42@gmail.com::rCKpiaGvroyttMpB:0212K X-Hashcash: 1:20:061026:pgsql-docs@postgresql.org::gaVPNHF7oKu24srE:000000000000 0000000000000000000000003pOV X-Hashcash: 1:20:061026:pgsql-hackers@postgresql.org::ixoYQBYyJzhY3csa:000000000 0000000000000000000000006dju X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.72 tagged_above=0 required=5 tests=SARE_SPEC_REPLICA X-Spam-Level: X-Archive-Number: 200610/112 X-Sequence-Number: 3833 --XF85m9dhOBO43t/C Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Thu, Oct 26, 2006 at 11:59:57AM -0400, Bruce Momjian wrote: > Jim C. Nasby wrote: > > 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. > > The problem is that we do have some solutions in our code, like doing > data partitioning in the application, warm standby, or using a shared > disk for failover, so how do we spell that out? I say there are > multiple solutions, but I don't see how I can say that all are external > and not included. Good point... how about this? -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) --XF85m9dhOBO43t/C Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename=patch Index: doc/src/sgml/failover.sgml =================================================================== RCS file: /projects/cvsroot/pgsql/doc/src/sgml/failover.sgml,v retrieving revision 1.2 diff -c -r1.2 failover.sgml *** doc/src/sgml/failover.sgml 26 Oct 2006 17:07:03 -0000 1.2 --- doc/src/sgml/failover.sgml 26 Oct 2006 18:26:21 -0000 *************** *** 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,40 ---- 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. A few of these solutions are ! provided with PostgreSQL itself, but it would be impractical for the core ! database to handle every scenario. That is why most solutions are implemented ! outside the database. PostgreSQL's unique extensibility is what allows this ! to happen, and 3rd-party solutions should not be thought of as ! second-rate simply because they are not bundled with the database. --XF85m9dhOBO43t/C--