Object-Relational DBMS

Streaming Replication for PostgreSQL 0.9-Beta

Jessica Thornsby

The first beta of PostgreSQL version 9.0 is now available.

PostgreSQL is an open source, object-relational database system. It is released under the PostgreSQL License.

This version introduces two new features, hot standby and streaming replication. Hot standby, means that PostgreSQL can connect to the server and run read-only queries while the server is in archive recovery; meanwhile, streaming replication means that a standby server can connect to the primary server and receive Write Ahead Log records as they are generated. Other new features include prefix support for the full text search synonym dictionary, and the ability to control large object permissions with GRANT/REVOKE. Please see the Release Notes for more information.