wal_level

A GUC parameter determining the level of detail written to WAL

wal_level is a GUC parameter determining the level of detail written to WAL.

wal_level was added in PostgreSQL 9.0.

Default value

The default value for wal_level is: minimal

Permissible values

  • • accepted
  • ◦ accepted but deprecated
  minimal archive hot_standby replica logical
PostgreSQL 14
PostgreSQL 13
PostgreSQL 12
PostgreSQL 11
PostgreSQL 10
PostgreSQL 9.6  
PostgreSQL 9.5  
PostgreSQL 9.4  
PostgreSQL 9.3    
PostgreSQL 9.2      
PostgreSQL 9.1    
PostgreSQL 9.0    

Usage

The current value of wal_level is one of the GUC configuration parameters recorded in pg_control.

Change history

Categories

GUC configuration item, Replication, WAL

See also

hot_standby, wal_log_hints, wal_skip_threshold