This talk explains what is stored in the WAL, how binary and logical replication work, and how replication slots track replication progress
The Postgres write-ahead log, or WAL, is basically a change-log for the database. It enables several important Postgres features: crash recovery, point-in-time recovery, and binary and logical replication. This talk explains what is stored in the WAL, how binary and logical replication work, and how replication slots track replication progress.
The Wonderful World of WAL
Bruce Momjian
EDB
This talk explains what is stored in the WAL, how binary and logical replication work, and how replication slots track replication progress
The Postgres write-ahead log, or WAL, is basically a change-log for the database. It enables several important Postgres features: crash recovery, point-in-time recovery, and binary and logical replication. This talk explains what is stored in the WAL, how binary and logical replication work, and how replication slots track replication progress.