Re: streaming replication breaks horribly if master crashes

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: streaming replication breaks horribly if master crashes
Date: 2010-06-16 20:00:37
Message-ID: 4C18E71502000025000324AC@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Robert Haas <robertmhaas(at)gmail(dot)com> wrote:

> So, obviously at this point my slave database is corrupted beyond
> repair due to nothing more than an unexpected crash on the master.

Certainly that's true for resuming replication. From your
description it sounds as though the slave would be usable for
purposes of taking over for an unrecoverable master. Or am I
misunderstanding?

> had no trouble getting back in sync with the master - but it would
> have done this after having replayed WAL that, from the master's
> point of view, doesn't exist. In other words, the database on the
> slave would be silently corrupted.
>
> I don't know what to do about this, but I'm pretty sure we can't
> ship it as-is.

I'm sure we can't.

-Kevin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stefan Kaltenbrunner 2010-06-16 20:07:26 Re: streaming replication breaks horribly if master crashes
Previous Message Joshua D. Drake 2010-06-16 19:53:09 Re: streaming replication breaks horribly if master crashes