PostgreSQL 9.0 arrives with many new features
Oct 01, 2010, 12:02 (0 Talkback[s])
(Other stories by Josh Berkus)
Full Text Search: The Key to Better Natural Language Queries for NoSQL in Node.js
"Version 9.0 of the PostgreSQL database management system was
released on September 20, with considerably more "buzz" than a
PostgreSQL release has had in a while. The PostgreSQL Project does
a major release every year, but this one is special. It has more
than a dozen major features and nearly 200 minor improvements, so
the release has more new goodies in it for database geeks than any
release before it, hence the "9.0" version number.
"It includes some things which users have been requesting for
years, such as built-in replication. Given this large number of new
features, I'm not even going to try to cover them all; instead,
I'll pick five very different features as examples and you can read
about the rest on PostgreSQL.org.
"PostgreSQL 9.0 includes a new mechanism for replicating entire
databases which uses binary logs to replicate between servers.
Since this is very similar to Oracle's Hot Standby Databases, it is
often also called "hot standby". While PostgreSQL already has
several other replication tools, including Slony-I, pgPool2, and
Bucardo, binary replication supports greater scalability and
availability for the majority of PostgreSQL users. It is also
simpler to configure and initialize for the most basic
configuration: two identical databases with failover."