PostgreSQL Replication - Second Edition

by Hans-Jurgen Schonig

Overview

PostgreSQL offers a comprehensive set of replication related features. Unleashing the power of PostgreSQL provides you with countless opportunities and a competitive advantage over other database systems.

This book will guide you through the most important concepts of PostgreSQL replication. It contains all the information you need to design and operate replicated setups.

Beginning by giving you an understanding of replication concepts, the PostgreSQL transaction log, and Point-in-time Recovery, we gradually move on to setting up asynchronous and synchronous replication. Next up, you will learn to monitor a PostgreSQL cluster setup, deal with monitoring tools, and then move on to understanding Linux High Availability. Further, we explore widely-used tools such as Slony, SkyTools, Postgres-XC, and walbouncer, and set up PL/Proxy.

Finally, you'll get acquainted with the new technology of BDR, which allows bidirectional replication in PostgreSQL.

Product Details

ISBN-13:	9781783988549
Publisher:	Packt Publishing
Publication date:	07/28/2015
Sold by:	Barnes & Noble
Format:	eBook
Pages:	322
File size:	2 MB

About the Author

Hans-Jurgen Schonig has 15 years of experience with PostgreSQL. He is the CEO of a PostgreSQL consulting and support company called Cybertec Schonig & Schonig GmbH (www.postgresql-support.de). It has successfully served countless customers around the globe.
Before founding Cybertec Schonig & Schonig GmbH in 2000, he worked as a database developer at a private research company focusing on the Austrian labor market, where he primarily focused on data mining and forecast models. He has also written several books about PostgreSQL.