PostgreSQL 9.0 Adds Replication Technology to Open-Source Database
With the Oracle OpenWorld 2010 conference under way in San Francisco, rival enterprise database PostgreSQL was updated with new replication technology.The latest version of open-source database PostgreSQL is now available, this time bringing with it new hot standby and replication capabilities. In 9.0, users can find more than a dozen major features touching on everything from security to performance. The replication and hot standby enhancements, however, have garnered the most attention. The streaming replication technology allows continuous archive (WAL) files to be streamed over a network connection to a standby server. Hot standby, meanwhile, enables continuous archive standby servers to execute read-only queries.
"The built-in replication in 9.0 and ability to query a hot standby have been the most requested PostgreSQL features for many years," said Simon Riggs, CTO of 2ndQuadrant and lead contributor to hot standby, in a statement. "Efficient, low latency streaming replication protects your data better, while hot standby significantly reduces total cost of ownership. In proprietary products, this capability is an add-on which costs thousands of dollars."