10

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 – that will be remedied 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
  • Setting up an HA cluster using Patroni

By the end of this ...

Get Mastering PostgreSQL 15 - Fifth 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.