Making Sense of Backups and Replication

In Chapter 9, Handling Backup and Recovery, we learned a lot about backup and recovery, which is essential for administration. So far, only logical backups have been covered; I am about to change that in this chapter.

This chapter is all about PostgreSQL's transaction log and what we can do with it to improve our setup and make things more secure.

In this chapter, we will cover the following topics:

  • Understanding the transaction log
  • Transaction log archiving and recovery
  • Setting up asynchronous replication
  • Upgrading to synchronous replication
  • Making use of replication slots
  • Making use of the CREATE PUBLICATION and CREATE SUBSCRIPTION commands

By the end of this chapter, you will be able to set up ...

Get Mastering PostgreSQL 13 - Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.