Not logged in
Log in now
Create an account
Subscribe to LWN
LWN.net Weekly Edition for May 23, 2013
An "enum" for Python 3
An unexpected perf feature
LWN.net Weekly Edition for May 16, 2013
A look at the PyPy 2.0 release
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