From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: streaming replication breaks horribly if master crashes |
Date: | 2010-06-16 19:53:09 |
Message-ID: | 1276717989.25660.428.camel@jd-desktop.unknown.charter.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Wed, 2010-06-16 at 15:47 -0400, Robert Haas wrote:
> So, obviously at this point my slave database is corrupted beyond
> repair due to nothing more than an unexpected crash on the master.
> That's bad. What is worse is that the system only detected the
> corruption because the slave had crossed an xlog segment boundary
> which the master had not crossed. Had it been otherwise, when the
> slave rewound to the beginning of the current segment, it would have
> 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.
The slave must be able to survive a master crash.
Joshua D. Drake
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise Postgres Company
>
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2010-06-16 20:00:37 | Re: streaming replication breaks horribly if master crashes |
Previous Message | Robert Haas | 2010-06-16 19:47:11 | streaming replication breaks horribly if master crashes |