3rd May 2011
|
|
Administrator
|
|
Join Date: May 2008
Location: Budel - the Netherlands
Posts: 4,132
|
|
PostgreSQL 9.1 beta adds synchronous replication
From http://www.h-online.com/open/news/it...n-1236505.html
Quote:
|
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
|