Re: Replication Ideas - Mailing list pgsql-general

From Tom Lane
Subject Re: Replication Ideas
Date
Msg-id 25356.1062013099@sss.pgh.pa.us
Whole thread Raw
In response to Re: Replication Ideas  ("Marc G. Fournier" <scrappy@hub.org>)
List pgsql-general
"Marc G. Fournier" <scrappy@hub.org> 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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Again about temporary table
Next
From: "scott.marlowe"
Date:
Subject: Re: What is the fastest way to get a resultset