Case Study: PostgreSQL DB Replication Between AWS Regions
In this article I describe how we created a redundant PostgreSQL database on the Amazon cloud using EBSÂ snapshots as backups to deploy a PostgreSQL DB server DR mobile application for one of our customers.
PostgreSQL 9.1 includes new capabilities for asynchronous fast replication syncing between master and slaves. The master server streams new data to the current available slave. This version includes great improvements that generated significant fast WAL (Write Ahead Log) processing, which generates replication and fast launching capabilities for the slave servers.
