Request a Demo
Home   >   mailing lists

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

From Samrat Revagade
Subject Re: Inconsistent DB data in Streaming Replication
Date
Msg-id CAF8Q-GwjduHPwERW4jewX8CkVCk6PWeMmdENBiJLo+R6-9Vi+w@mail.gmail.com
Whole thread Raw
In response to Re: Inconsistent DB data in Streaming Replication  (Samrat Revagade <revagade.samrat@gmail.com>)
Responses Re: Inconsistent DB data in Streaming Replication
List pgsql-hackers
Tree view

>(5) The master then forces a write of the data page related to this transaction.

Sorry, this is incorrect. Whenever the master writes the data page it checks that the WAL record is written in standby till that LSN. 


>While master is waiting to force a write (point 5) for this data page, streaming replication continuous.

>Also other data page writes are not dependent on this particular page write. So the commit of data >pages are not serialized.

Sorry, this is incorrect. Streaming replication continuous, master is not waiting, whenever the master writes the data page it checks that the WAL record is written in standby till that LSN.


Regards,

Samrat


pgsql-hackers by date:

Previous
From: Dang Minh Huong
Date:
Subject: Re: [BUGS] replication_timeout not effective
Next
From: Ants Aasma
Date:
Subject: Re: Enabling Checksums