PostgreSQL Replication

Replication is an advanced subject but this tutorial makes it so simple to assimilate thanks to a carefully structured approach based on examples and screenshots. As a PostrgreSQL administrator it will expand your horizons.
Code Files

PostgreSQL Replication

Zoltan Böszörmenyi, Hans-Jürgen Schönig

1 customer reviews
Replication is an advanced subject but this tutorial makes it so simple to assimilate thanks to a carefully structured approach based on examples and screenshots. As a PostrgreSQL administrator it will expand your horizons.
Packt Subscription
$5.00
$9.99/m after first month
eBook
$5.00
RRP $29.99
Save 83%
Print + eBook
$49.99
RRP $49.99
What do I get with a Packt subscription?
  • Exclusive monthly discount - no contract
  • Unlimited access to entire Packt library of 6500+ eBooks and Videos
  • 120 new titles added every month, on new and emerging tech
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
$5.00
$5.00
$49.99
$9.99/m after first month
RRP $29.99
RRP $49.99
Subscription
eBook
Print + eBook
Subscribe Now

Frequently bought together


PostgreSQL Replication Book Cover
PostgreSQL Replication
$ 29.99
$ 5.00
PostgreSQL 9 Administration Cookbook - Second Edition Book Cover
PostgreSQL 9 Administration Cookbook - Second Edition
$ 47.99
$ 5.00
Buy 2 for $10.00
Save $67.98
Add to Cart

Book Details

ISBN 139781849516723
Paperback250 pages

Book Description

PostgreSQL offers a comprehensive set of replication related features, which can be used to make your database servers more robust and way more scalable. Unleashing the power of PostgreSQL provides the user with countless opportunities and a competitive advantage over other database systems. To make things more powerful, PostgreSQL can be used in conjunction with a handful of sophisticated tools serving various different needs such as queuing, logical replication, or simplified transaction log handling.

"PostgreSQL Replication" is a practical, hands-on guide to PostgreSQL replication. It will provide you with the theoretical background as well as simple examples showing you how to make replication work on your system. A broad toolchain will be presented along with mature PostgreSQL-core technology.

"PostgreSQL Replication" starts with an introduction to replication concepts as well as the physical limitations of different replication solutions. You will be guided through various techniques such as Point-In-Time-Recovery, transaction-log-based replication and you will be introduced to a set of replication-related tools. In the final chapter you will learn to scale PostgreSQL to many different servers using PL/Proxy.

You will learn how to reset PostgreSQL to a certain point in time and figure out how to replicate data in many ways. You will deal with both synchronous as well as asynchronous replication. In addition to that, the book covers important topics, such as Slony, and upgrades with virtually no downtime. We will also cover important performance-related topics to make sure your database setups will provide you with high speed AND high availability.

"PostgreSQL Replication" contains all the information you need to design and operate replicated setups. You will learn everything you need to know for your daily work and a lot more.

Table of Contents

What You Will Learn

  • Recover a PostgreSQL database to a certain point in time
  • Set up asynchronous and synchronous streaming replication
  • Handle transaction log files efficiently
  • Learn about Linux High Availability
  • Get to grips with Slony replication
  • Get PL/Proxy to scale infinitely
  • Understand pgpool and pgbouncer to improve speed and reliability
  • Perform fast on-the-fly backups
  • Increase reliability and throughput
  • Improve data security and geographically distribute data

Authors

Table of Contents

Book Details

ISBN 139781849516723
Paperback250 pages
Read More
From 1 reviews

Read More Reviews

Recommended for You

PostgreSQL 9 Administration Cookbook - Second Edition Book Cover
PostgreSQL 9 Administration Cookbook - Second Edition
$ 47.99
$ 5.00
PostgreSQL 9 High Availability Cookbook Book Cover
PostgreSQL 9 High Availability Cookbook
$ 26.99
$ 5.00
MySQL Management and Administration with Navicat Book Cover
MySQL Management and Administration with Navicat
$ 17.99
$ 5.00
Learn HTML5 by Creating Fun Games Book Cover
Learn HTML5 by Creating Fun Games
$ 29.99
$ 5.00
HTML5 Game Development HOTSHOT Book Cover
HTML5 Game Development HOTSHOT
$ 26.99
$ 5.00
HTML5 and CSS3 Transition, Transformation, and Animation Book Cover
HTML5 and CSS3 Transition, Transformation, and Animation
$ 20.99
$ 5.00