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 24720D1B8B1 for ; Tue, 26 Aug 2003 03:02:05 -0300 (ADT) 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 92036-03 for ; Tue, 26 Aug 2003 03:01:35 -0300 (ADT) Received: from ganymede.hub.org (u173n10.eastlink.ca [24.224.173.10]) by svr1.postgresql.org (Postfix) with ESMTP id 49EC9D1B8B3 for ; Tue, 26 Aug 2003 03:01:32 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id ACEC33427F; Tue, 26 Aug 2003 03:01:26 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id A8F8033D0E; Tue, 26 Aug 2003 03:01:26 -0300 (ADT) Date: Tue, 26 Aug 2003 03:01:26 -0300 (ADT) From: "Marc G. Fournier" To: Tom Lane Cc: Chris Travers , Alvaro Herrera , Ron Johnson , pgsql-general@postgresql.org Subject: Re: Replication Ideas In-Reply-To: <11627.1061845759@sss.pgh.pa.us> Message-ID: <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> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/1458 X-Sequence-Number: 47874 On Mon, 25 Aug 2003, Tom Lane wrote: > Chris Travers writes: > > Yes I have. Postgres-r is not a high-availability solution which is > > capable of transparent failover, > > 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? note that I did go through the 'docs' on how it works, and am/was quite impressed at what they were doing ... but, if I have a large network, say, and one group is connecting to ServerA, and another group with ServerB, what happens when ServerA and ServerB loose network connectivity for any period of time? How do they re-sync when the network comes back up again?