PostgreSQL 9.1 Gets Synchronous

"PostgreSQL 9.1 is now available in beta, introducing a number of new features. Among the new features is support for synchronous replication for the database.

In the beta there is also something called transaction-controlled synchronous replication, which provides control over what is and isn't replicated.

"What that means is the database administrator can decide on a per-transaction basis which ones need to be replicated and which ones don't," Josh Berkus of the PostgreSQL core team said. "The advantage of that is that there are a lot of mixed load applications which might have a small amount of essential data and a large amount of data that is not as important."

Complete Story

Related Stories:

• Best Linux Desktop Backup Utilities(Apr 19, 2011)
• SSL Certificates For PostgreSQL(Jan 02, 2011)
• Troubleshooting MySQL Slow Queries with Tcpdumps(Dec 22, 2010)
• PostgreSQL: Tips and TricksPostgreSQL(Dec 21, 2010)
• Lessons from PostgreSQL's Git transition(Oct 27, 2010)
• PostgreSQL 9 Advances Database Replication(Sep 21, 2010)