Database Reference
In-Depth Information
id | value
----+-------
1 | one
Congratulations! The streaming replication works.
How it works...
Asdemonstratedinthisrecipe,thebasicsetupforstreamingreplicationisstraight-
forward. Changes made to the primary database server are quickly pushed to the
standby database server.
Therearethird-partyapplicationstohelpestablish,administer,andmaintainstream-
ingreplicationonproductionservers.Theseapplicationspermitcomplexreplication
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,whichisavailableat
http://postgresxc.wikia.com/wiki/Postgres-
• Slony-I, which isavailable at
http://slony.info