Re: Inconsistent DB data in Streaming Replication - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Inconsistent DB data in Streaming Replication
Date
Msg-id 14775.1365436353@sss.pgh.pa.us
Whole thread Raw
In response to Inconsistent DB data in Streaming Replication  (Samrat Revagade <revagade.samrat@gmail.com>)
List pgsql-hackers
Samrat Revagade <revagade.samrat@gmail.com> writes:
> We have been trying to figure out possible solutions to the following
> problem in streaming replication Consider following scenario:

> If master receives commit command, it writes and flushes commit WAL records
> to the disk, It also writes and flushes data page related to this
> transaction.

> The master then sends WAL records to standby up to the commit WAL record.
> But before sending these records if failover happens then,  old master is
> ahead of  standby which is now the new master in terms of DB data leading
> to inconsistent data .

I don't exactly see the problem ... unless you're imagining that master
and slave share the same data storage or something like that.  That's
not going to work for a ton of reasons besides this one.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: Inconsistent DB data in Streaming Replication
Next
From: Jeff Bohmer
Date:
Subject: Re: [BUGS] BUG #8043: 9.2.4 doesn't open WAL files from archive, only looks in pg_xlog