PostgreSQL Replication - Second Edition

Leverage the power of PostgreSQL replication to make your databases more robust, secure, scalable, and fast
Code Files

PostgreSQL Replication - Second Edition

Hans-Jürgen Schönig

8 customer reviews
Leverage the power of PostgreSQL replication to make your databases more robust, secure, scalable, and fast
Mapt Subscription
FREE
$30.00/m after trial
eBook
$25.20
RRP $35.99
Save 29%
Print + eBook
$44.99
RRP $44.99
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$0.00
$25.20
$44.99
$29.99 p/m after trial
RRP $35.99
RRP $44.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


PostgreSQL Replication - Second Edition Book Cover
PostgreSQL Replication - Second Edition
$ 35.99
$ 25.20
PostgreSQL High Availability Cookbook - Second Edition Book Cover
PostgreSQL High Availability Cookbook - Second Edition
$ 43.99
$ 30.80
Buy 2 for $35.00
Save $44.98
Add to Cart

Book Details

ISBN 139781783550609
Paperback322 pages

Book Description

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.

Table of Contents

What You Will Learn

  • Use Point-in-time Recovery to perform data recovery as well as replication
  • Set up synchronous as well as asynchronous streaming replication
  • Get familiarized with the transaction log, the core component of most replication setups and its purpose
  • Improve speed and reliability with an understanding of pgpool and PgBouncer
  • Increase your data security and geographically distribute data
  • Make your systems more available and secure with Linux High Availability
  • Scale out with PL/Proxy and Postgres-XC
  • Detect, investigate, and solve replication-related problems

Authors

Table of Contents

Book Details

ISBN 139781783550609
Paperback322 pages
Read More
From 8 reviews

Read More Reviews

Recommended for You

PostgreSQL High Availability Cookbook - Second Edition Book Cover
PostgreSQL High Availability Cookbook - Second Edition
$ 43.99
$ 30.80
PostgreSQL Administration Cookbook, 9.5/9.6 Edition Book Cover
PostgreSQL Administration Cookbook, 9.5/9.6 Edition
$ 47.99
$ 33.60
PostgreSQL 9.6 High Performance Book Cover
PostgreSQL 9.6 High Performance
$ 39.99
$ 28.00
PostgreSQL High Performance Cookbook Book Cover
PostgreSQL High Performance Cookbook
$ 43.99
$ 30.80
Learning PostgreSQL 10 - Second Edition Book Cover
Learning PostgreSQL 10 - Second Edition
$ 27.99
$ 19.60
Mastering PostgreSQL 9.6 Book Cover
Mastering PostgreSQL 9.6
$ 43.99
$ 30.80