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=logical

Related terms

Taught in

References

Certification courses