On 06.10.2010 17:20, Simon Riggs wrote:
> On Wed, 2010-10-06 at 15:26 +0300, Heikki Linnakangas wrote:
>
>> You're not going to get zero data loss that way.
>
> Ending the wait state does not cause data loss. It puts you at *risk* of
> data loss, which is a different thing entirely.
Looking at it that way, asynchronous replication just puts you at risk
of data loss too, it doesn't necessarily mean you get data loss.
The key is whether you are guaranteed to have zero data loss or not. If
you don't wait forever, you're not guaranteed zero data loss. It's just
best effort, like asynchronous replication. The situation you want to
avoid is that the master dies, and you don't know if you have suffered
data loss or not.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com