X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A6BD854423; Sun, 24 Apr 2005 15:06:51 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 28109-10; Sun, 24 Apr 2005 18:06:40 +0000 (GMT) Received: from servata.com (unknown [216.152.249.226]) by svr1.postgresql.org (Postfix) with ESMTP id 1A317543F1; Sun, 24 Apr 2005 15:06:32 -0300 (ADT) Received: from [216.9.42.72] (helo=216-9-42-72.rpp.access.nethere.net) by servata.com with esmtpa (Exim 4.50) id 1DPn5Z-0001kH-RC; Sun, 24 Apr 2005 12:48:21 -0700 Subject: Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item. From: Jeff Davis To: Bruce Momjian Cc: "Marc G. Fournier" , Robert Treat , PostgreSQL-documentation In-Reply-To: <200504241201.j3OC15V17101@candle.pha.pa.us> References: <200504241201.j3OC15V17101@candle.pha.pa.us> Content-Type: text/plain Date: Sun, 24 Apr 2005 11:04:42 -0700 Message-Id: <1114365882.3567.21.camel@jeff> Mime-Version: 1.0 X-Mailer: Evolution 2.2.2 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/21 X-Sequence-Number: 2951 Should the text include a mention of synchronous vs. asynchronous? Or does master-master imply synchronous? Regards, Jeff Davis On Sun, 2005-04-24 at 08:01 -0400, Bruce Momjian wrote: > Marc G. Fournier wrote: > > On Tue, 16 Nov 2004, Robert Treat wrote: > > > > > On Sunday 14 November 2004 16:33, Bruce Momjian wrote: > > >> Log Message: > > >> ----------- > > >> Remove replicaiton FAQ item. > > >> > > >> Modified Files: > > >> -------------- > > >> pgsql/doc: > > >> FAQ (r1.269 -> r1.270) > > >> > > >> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/FAQ.diff?r1=1.269&r2= > > >> 1.270) pgsql/doc/src/FAQ: > > >> FAQ.html (r1.227 -> r1.228) > > >> > > >> (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/FAQ/FAQ.html.diff > > >> ?r1=1.227&r2=1.228) > > > > > > While the answer may have been a little dated, this still seems to be an FAQ. > > > Was there a discussion on removing this? If so I'll go read that, but ISTM > > > this question should remain. > > > > agreed, this definitly does fall under a "Very FAQ" kinda thing ... > > pointers to the various methods that are currently in use, at a minimum, > > would be good ... > > Yep, big mistake my removing the replication FAQ item. I have re-added a > new one: > > 4.21) What replication solutions are available? > > Though "replication" is a single term, there are two major replication > technologies. Multi-master replication allows read/write queries to be > sent to multiple replicated computers. Using this capability has a > serious performance impact. Pgcluster is the most popular such solution > available for PostgreSQL. Master-slave replication allows a single > master to receive read/write queries, with slaves able to accept only > read/SELECT queries. The most popular master-slave PostgreSQL > replication solution is Slony. There are also commercial and > hardware-based replication solutions available. >