View Single Post
  #1   (View Single Post)  
Old 12th September 2011
J65nko J65nko is offline
Join Date: May 2008
Location: Budel - the Netherlands
Posts: 3,989
Default PostgreSQL 9.1 with synchronous replication


The main innovation in version 9.1 of the free database server PostgreSQL, is synchronous replication. 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, but can now be limited to individual transactions. While the superuser used to be the only one who could launch replication, the new privilege replication can be assigned to any user or role.
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