wal_level

A configuration parameter determining the level of detail written to WAL

wal_level is a configuration 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:

Permissible values

  • • accepted
  • ◦ accepted but deprecated
  • * default
  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

wal_level can only be changed by a PostgreSQL restart.

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

Change history

Categories

GUC configuration item, Replication, WAL

See also

hot_standby, wal_log_hints, wal_skip_threshold