Peripheral Links
Header And Logo
Site Navigation
About Postgres-R
Postgres-R is an extension to the relational database system Postgres, providing efficient, fast and consistent database replication for clusters. It is designed to be as transparent as possible to the client, stable and secure by default.
The primary use of Postgres-R is to build load-balancing and high-availability database systems on commodity hardware. Furthermore, due to the flexible architecture of Postgres-R it is easily possible to extend or adjust the replication process to many different means. Compared to common single node database systems, a Postgres-R cluster is more reliable and scales better while being cheaper and more flexible.
Reliability, Availability and Scalability
Mirroring the data on multiple nodes enhances reliability of the database system. As Postgres-R is using a group communication system it is easily possible to add or remove nodes on the running system. Crashing nodes are automatically detected and removed, thus do not affect the operating of the database system. This facilitates administration tasks and ensures greater availability and scalability of the database system.
Performance
In synchronously replicated database systems like Postgres-R, read-only queries can be easily balanced across the nodes of the system. Thanks to its tight integration into the database system and its transaction serializing mechanism, Postgres-R handles writing transactions quite well, too.
Community project
Postgres-R has been released under the same license as Postgres itself, so users have all the benefits of free software.