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 transaction log archiving and replication. Keep in mind that this chapter could never be a comprehensive guide to replication; it is only...
