As demonstrated in this recipe, the basic setup for streaming replication is straightforward. Changes made to the primary database server are quickly pushed to the standby database server.
There are third-party applications to help establish, administer, and maintain streaming replication on production servers. These applications permit complex replication strategies, including multimaster, multistandby, and proper failover. A few of these applications include the following:
- Pgpool-II, which is available at http://www.pgpool.net
- Bucardo, which is available at http://bucardo.org/wiki/Bucardo
- Postgres-XC, which is available at http://postgresxc.wikia.com/wiki/Postgres-XC_Wiki
- Slony-I, which is available at http://slony.info ...