X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id E83B6D1B8AE for ; Wed, 27 Aug 2003 19:39:06 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 07657-10 for ; Wed, 27 Aug 2003 16:38:37 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 11235D1B8E4 for ; Wed, 27 Aug 2003 16:38:35 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h7RJcJ5H025357; Wed, 27 Aug 2003 15:38:19 -0400 (EDT) To: "Marc G. Fournier" Cc: Chris Travers , Alvaro Herrera , Ron Johnson , pgsql-general@postgresql.org Subject: Re: Replication Ideas In-reply-to: <20030826025754.V691@ganymede.hub.org> References: <3F483EBD.3020108@travelamericas.com> <1061705587.3733.452.camel@haggis> <3F4A420E.6090604@travelamericas.com> <20030825182441.GB9597@dcc.uchile.cl> <3F4A5724.3060002@travelamericas.com> <11627.1061845759@sss.pgh.pa.us> <20030826025754.V691@ganymede.hub.org> Comments: In-reply-to "Marc G. Fournier" message dated "Tue, 26 Aug 2003 03:01:26 -0300" Date: Wed, 27 Aug 2003 15:38:19 -0400 Message-ID: <25356.1062013099@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/1469 X-Sequence-Number: 47885 "Marc G. Fournier" writes: > On Mon, 25 Aug 2003, Tom Lane wrote: >> What makes you say that? My understanding is it's supposed to survive >> loss of individual servers. > How does it play 'catch up' went a server comes back online? The recovered server has to run through the part of the GCS data stream that it missed the first time. This is not conceptually different from recovering using archived WAL logs (or archived trigger-driven replication data streams). As with using WAL for recovery, you have to be able to archive the message stream until you don't need it any more. regards, tom lane