3.1.17 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 readability of the DEBUG statement log messages.

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)

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.

Default Value:

on

See Also

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

Item Details

Category: AUDIT AND ACCOUNTABILITY

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

Plugin: PostgreSQLDB

Control ID: 222f628df5d9991c8c8d39b0d620aa8a17f9cb8365f59f53a261bac1bdd2732f