View Single Post
  #1   (View Single Post)  
Old 3rd May 2011
J65nko J65nko is offline
Join Date: May 2008
Location: Budel - the Netherlands
Posts: 3,507
Default PostgreSQL 9.1 beta adds synchronous replication


PostgreSQL 9.1 should be out within the next four months; the development team has now released the first beta version of the open source SQL database. It includes a synchronous replication mode which ensures that transactions concluded with COMMIT will always reach slave nodes. Asynchronous replication, until now the only available replication mode, has the drawback that data loss can occur if the master crashes after the COMMIT but before sending the data to the slaves. Synchronous replication ensures that, for each write transaction, the master waits until at least one slave node has written the data to its transaction log. This increase in reliability comes at the cost of longer response times. PostgreSQL 9.1 will continue to offer asynchronous replication.
You don't need to be a genius to debug a pf.conf firewall ruleset, you just need the guts to run tcpdump
Reply With Quote