3.1.26 Ensure 'log_timezone' is set correctly

Warning! Audit Deprecated

This audit has been deprecated and will be removed in a future update.

View Next Audit Version

Information

The log_timezone setting specifies the time zone to use in timestamps within log messages. This value is cluster-wide, so that all sessions will report timestamps consistently. Unless directed otherwise by your organization's logging policy, set this to either GMT or UTC.

Rationale:

Log entry timestamps should be configured for an appropriate time zone as defined by your organization's logging policy to ensure a lack of confusion around when a logged event occurred.

Note that this setting affects only the timestamps present in the logs. It does not affect the time zone in use by the database itself (for example, select now()), nor does it affect the host's time zone.

Solution

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

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

Default Value:

By default, the PGDG packages will set this to match the server's timezone in the Operating System.

See Also

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

Item Details

References: CSCv7|6.3

Plugin: PostgreSQLDB

Control ID: cbc1170cadbda8f007f626302cc4e7f0bc9955aa264b1c3e2f4394b160971bc3