IT lexicon › Database › wal_level

wal_level

Database På svenska → Updated: 2026-07-30

The setting deciding how much information PostgreSQL writes into the transaction log. Changing it requires a restart, which is always discovered at the wrong moment.

There are three levels. minimal logs only what is needed to come back from a crash and permits shortcuts where certain bulk inserts skip the log entirely. replica is the default and adds what is needed for archiving, point-in-time recovery and streaming replicas. logical further includes enough for changes to be decoded into a logical stream of rows, which is the prerequisite for logical replication and for tools that capture changes into other systems. That last level costs measurably more log volume, especially if tables use full replica identity. Needing to restart the server to change it is the classic surprise when somebody wants to bolt change capture onto a running system.

← Back to the lexicon