3.1.20 Ensure 'log_checkpoints' is enabled

Information

Enabling the log_checkpoints setting causes checkpoints and restartpoints to be logged in the server log. Some statistics are included in the log messages, including the number of buffers written and the time spent writing them.
Rationale:
Enabling the logging of checkpoints is the easiest method of tracking both the frequency and duration of the checkpoint operations.

Solution

Execute the following SQL statement(s) to enable this setting:
postgres=# alter system set log_checkpoints = 'on';
ALTER SYSTEM
postgres=# select pg_reload_conf();
pg_reload_conf
----------------
t
(1 row)
Default Value:
off

See Also

https://workbench.cisecurity.org/files/2234

Item Details

Category: AUDIT AND ACCOUNTABILITY

References: 800-53|AU-12, CSCv6|6, CSCv7|6.3

Plugin: PostgreSQLDB

Control ID: c611988e49b4e18d5496708799a684aa3d76ab9f6d1d951a45dedebe83c5d249