3.1.19 Ensure 'debug_pretty_print' is enabled

Information

Enabling debug_pretty_print indents the messages produced by debug_print_parse, debug_print_rewritten, or debug_print_plan making them significantly easier to read.

Rationale:

If this setting is disabled, the 'compact' format is used instead, significantly reducing the readability of the DEBUG statement log messages.

Impact:

Be advised that the aforementioned DEBUG printing options are disabled, but if your organizational logging policy requires them to be on then this option comes into play.

Solution

Execute the following SQL statement(s) to enable this setting:

postgres=# alter system set debug_pretty_print = 'on';
ALTER SYSTEM
postgres=# select pg_reload_conf();
pg_reload_conf
----------------
t
(1 row)

Default Value:

on

See Also

https://workbench.cisecurity.org/benchmarks/17004

Item Details

Category: AUDIT AND ACCOUNTABILITY

References: 800-53|AU-3, 800-53|AU-3(1), 800-53|AU-7, 800-53|AU-12, CSCv7|6.3

Plugin: PostgreSQLDB

Control ID: 35668f7bf7fa05d3f7f97a2983ca074e7da645fe98ddd8466e9504b614593a0e