PostgreSQL Replication

PostgreSQL Replication

Zoltan Böszörmenyi

Replication is a complicated topic yet this instructional makes it so uncomplicated to assimilate due to a gently dependent technique according to examples and screenshots. As a PostrgreSQL administrator it's going to extend your horizons.


  • Explains the hot replication beneficial properties brought in PostgreSQL 9
  • Contains effortless to appreciate reasons and many screenshots that simplify a complicated subject like replication
  • Teaches PostgreSQL directors how you can retain consistency among redundant assets and to enhance reliability, fault-tolerance, and accessibility

In Detail

PostgreSQL bargains a finished set of replication comparable positive factors, that are used to make your database servers extra strong and far more scalable. Unleashing the facility of PostgreSQL presents the consumer with numerous possibilities and a aggressive virtue over different database platforms. To make issues extra robust, PostgreSQL can be utilized along with a handful of subtle instruments serving quite a few diverse wishes akin to queuing, logical replication, or simplified transaction log handling.

"PostgreSQL Replication" is a realistic, hands-on advisor to PostgreSQL replication. it's going to offer you the theoretical heritage in addition to easy examples exhibiting you the way to make replication paintings in your procedure. A large toolchain could be awarded in addition to mature PostgreSQL-core technology.

"PostgreSQL Replication" begins with an advent to replication thoughts in addition to the actual obstacles of other replication options. you can be guided via a variety of concepts similar to Point-In-Time-Recovery, transaction-log-based replication and you'll be brought to a collection of replication-related instruments. within the ultimate bankruptcy you'll discover ways to scale PostgreSQL to many alternative servers utilizing PL/Proxy.

You will how one can reset PostgreSQL to a undeniable time limit and work out how you can mirror information in lots of methods. you'll take care of either synchronous in addition to asynchronous replication. as well as that, the e-book covers very important themes, similar to Slony, and improvements with almost no downtime. we'll additionally disguise vital performance-related issues to ensure your database setups gives you excessive pace AND excessive availability.

"PostgreSQL Replication" comprises all of the info you want to layout and function replicated setups. you'll research every thing you must recognize to your day-by-day paintings and much more.

What you are going to research from this book

  • Recover a PostgreSQL database to a definite aspect in time
  • Set up asynchronous and synchronous streaming replication
  • Handle transaction log records efficiently
  • Learn approximately Linux excessive Availability
  • Get to grips with Slony replication
  • Get PL/Proxy to scale infinitely
  • Understand pgpool and pgbouncer to enhance pace and reliability
  • Perform quickly on-the-fly backups
  • Increase reliability and throughput
  • Improve facts safeguard and geographically distribute data


This ebook has a bankruptcy devoted to every one point of replication. the hot good points of PostgreSQL nine are brought and there are numerous sensible examples and screenshots.

Show sample text content

Download sample