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 PUBLICATIONandCREATESUBSCRIPTIONcommands - Setting up an HA cluster using Patroni
By the end of this chapter, you will be able to set up transaction log archiving and replication. In addition to that, you will be able to understand basic concepts to handle High Availability and apply them in...
