write-ahead log
The log where PostgreSQL records every change before applying it to the data files, so it can recover after a crash.
In more detail
Setting wal_level to logical makes the log detailed enough for logical decoding, which change data capture reads. The default level is replica.
Example
postgres -c wal_level=logicalRelated terms
- logical decoding — The PostgreSQL feature that turns write-ahead log entries into readable row changes, such as inserts and updates with their values.
- change data capture — Reading every insert, update and delete from a database's own change log and turning them into a stream of events.
- PostgreSQL — A widely used open source relational database server with strict typing, rich data types and extensions.
Taught in
- The Connector That Was Created Twice — Confluent Apache Kafka Certifications (CCDAK and CCAAK) Exam Prep
- Change Data Capture In Principle — Apache Kafka & Event Streaming
- Where Did Two Hours Go? Prometheus Architecture — Prometheus Certified Associate (PCA) Exam Prep