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 841C75391F for ; Sun, 24 Apr 2005 13:50:30 -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 08753-04 for ; Sun, 24 Apr 2005 16:50:20 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by svr1.postgresql.org (Postfix) with ESMTP id BB0135374F for ; Sun, 24 Apr 2005 13:50:19 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id BDD4C30E8A; Sun, 24 Apr 2005 18:48:57 +0200 (MET DST) From: Christopher Browne X-Newsgroups: pgsql.docs Subject: Re: [COMMITTERS] pgsql: Remove replicaiton FAQ item. Date: Sun, 24 Apr 2005 12:11:13 -0400 Organization: cbbrowne Computing Inc Lines: 42 Message-ID: References: <20041116233105.H1910@ganymede.hub.org> <200504241201.j3OC15V17101@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4 (Jumbo Shrimp, linux) Cancel-Lock: sha1:aVvrwMJPq2lI8dagd6yn+DGZm0Q= To: pgsql-docs@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.39 tagged_above=0 required=5 tests=AWL, INFO_TLD X-Spam-Level: X-Archive-Number: 200504/33 X-Sequence-Number: 2963 Martha Stewart called it a Good Thing when pgman@candle.pha.pa.us (Bruce Momjian) wrote: > 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. A suggestion for rewording: Though "replication" is a single term, there are a number of approaches and technologies to handle it, and thus, for different purposes, a number of replication systems are available. Master/slave replication allows a single master to receive read/write queries, where slaves can only accept read/SELECT queries. The most popular freely available master-slave PostgreSQL replication solution is Slony-I. Multi-master replication allows read/write queries to be sent to multiple replicated computers. Using this capability generaly has a fairly severe impact on performance due to the need to synchronize changes between servers. Pgcluster is the most popular such solution freely available for PostgreSQL. There are also commercial and hardware-based replication solutions available supporting a variety of replication models. -- (format nil "~S@~S" "cbbrowne" "acm.org") http://linuxdatabases.info/info/slony.html "It can be shown that for any nutty theory, beyond-the-fringe political view or strange religion there exists a proponent on the Net. The proof is left as an exercise for your kill-file." -- Bertil Jonell