Re: Replication Ideas

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
Cc: Chris Travers <chris(at)travelamericas(dot)com>, Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Replication Ideas
Date: 2003-08-27 19:38:19
Message-ID: 25356.1062013099@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-performance

"Marc G. Fournier" <scrappy(at)hub(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-08-27 20:01:11 Re: Again about temporary table
Previous Message N.K. 2003-08-27 19:28:18 Pg_dump : Can I specify the Password ?

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Browne 2003-08-28 01:32:16 Re: Hardware recommendations to scale to silly load
Previous Message Markus Kräutner 2003-08-27 19:17:28 Possible bug in update?

Browse pgsql-performance by date

  From Date Subject
Next Message Michael Guerin 2003-08-27 21:40:05 Simple queries take forever to run
Previous Message Dennis Gearon 2003-08-27 16:57:36 Please scan your computer