Chapter 6. Handling Replication and Improving Performance

This chapter is dedicated to everything that is related to the PostgreSQL transaction log as well as replication. The following key topics will be covered in this chapter:

  • Understanding the PostgreSQL transaction log
  • Configuring checkpoints
  • Setting up an asynchronous replication
  • Upgrading to a synchronous replication
  • Monitoring the replication

At the end of the chapter you should be able to understand, set up, and debug a typical replication scenario with ease.

Understanding the PostgreSQL transaction log

Before digging into the world of replication, it makes sense to stop for a while and focus our attention on the PostgreSQL transaction log. Many people have heard about the transaction log but ...

Get PostgreSQL Administration Essentials now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.