Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 9DD539FA463; Thu, 26 Oct 2006 13:00:28 -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 28430-10; Thu, 26 Oct 2006 15:59:59 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id AD1E79FA3A3; Thu, 26 Oct 2006 12:59:58 -0300 (ADT) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id k9QFxv129610; Thu, 26 Oct 2006 11:59:57 -0400 (EDT) From: Bruce Momjian Message-Id: <200610261559.k9QFxv129610@momjian.us> Subject: Re: [HACKERS] Replication documentation addition In-Reply-To: <20061026155535.GU26892@nasby.net> To: "Jim C. Nasby" Date: Thu, 26 Oct 2006 11:59:57 -0400 (EDT) CC: Dawid Kuroczko , pgsql-docs@postgresql.org, pgsql-hackers@postgresql.org X-Mailer: ELM [version 2.4ME+ PL123] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.719 tagged_above=0 required=5 tests=SARE_SPEC_REPLICA, SPF_HELO_PASS, SPF_PASS, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200610/109 X-Sequence-Number: 3830 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. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +