PostGIS Cookbook - Second Edition

How it works...

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 ...