Book Image

PostgreSQL Administration Essentials

Book Image

PostgreSQL Administration Essentials

Overview of this book

Table of Contents (14 chapters)

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.