Not logged in
Log in now
Create an account
Subscribe to LWN
LWN.net Weekly Edition for December 5, 2013
Deadline scheduling: coming soon?
LWN.net Weekly Edition for November 27, 2013
ACPI for ARM?
LWN.net Weekly Edition for November 21, 2013
I think I'm in love with PostgreSQL. I can finally ditch the last our DB2 servers.
Synchronous replication! Yay!
Posted May 5, 2011 17:27 UTC (Thu) by intgr (subscriber, #39733)
Not sure what kind of synchronous replication you're looking for, but note that PostgreSQL 9.1's synchronous replication only guarantess durability of replicated data, not query consistency between master and slaves.
In simpler terms, it guarantees that no committed data will be lost when the master crashes, but slave nodes can still return stale data after rows are modified/deleted on the master. Replication lag still exists (though to a lesser degree).
Posted May 5, 2011 20:25 UTC (Thu) by Cyberax (✭ supporter ✭, #52523)
What happens when I commit a transaction? I understand that by the time COMMIT completes, the data is replicated to all the slaves. Right?
Posted May 6, 2011 7:30 UTC (Fri) by intgr (subscriber, #39733)
In the event of a failover/promotion, PostgreSQL applies all outstanding WAL changes, so no data is lost.
Copyright © 2013, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds