Summary
Azure Database for PostgreSQL writes all database changes to a log file before committing the changes to disk, and is called write-ahead logging. In this module, you learned how PostgreSQL prevents data loss if a problem arises by using the write-ahead log. You learned about high availability (HA), and how HA uses the write-ahead log to replicate your data. You learned about logical decoding, and how you can configure your server to stream data. You also learned how to set up a second server, and replicate data from your main server to your second server to maintain a second copy of your data.
After completing this module, you're able to:
- Describe write-ahead logging.
- Understand replication and logical decoding.
For more information about the topics covered in this module, see:
- Logical replication and logical decoding - Azure Database for PostgreSQL - Flexible Server | Microsoft Learn
- Overview of zone redundant high availability with Azure Database for PostgreSQL - Flexible Server | Microsoft Learn
- Change data capture in Postgres: How to use logical decoding and wal2json - Microsoft Tech Community