Detections
Analytics
CD16-00-007500 - PostgreSQL must record time stamps in audit records and application data that can be mapped to Coordinated Universal Time (UTC), formerly Greenwich Mean Time (GMT).
Information
If time stamps are not consistently applied and there is no common time reference, it is difficult to perform forensic analysis.Time stamps generated by PostgreSQL must include date and time. Time is commonly expressed in UTC, a modern continuation of GMT, or local time with an offset from UTC.
Some DBMS products offer a data type called TIMESTAMP that is not a representation of date and time. Rather, it is a database state counter and does not correspond to calendar and clock time. This requirement does not refer to that meaning of TIMESTAMP.
Solution
Note: The following instructions use the PGDATA and PGVER environment variables. Refer to APPENDIX-F for instructions on configuring PGDATA and APPENDIX-H for PGVER.To change log_timezone in postgresql.conf to use a different time zone for logs, as the database administrator (shown here as "postgres"), run the following:
$ sudo su - postgres
$ vi ${PGDATA?}/postgresql.conf
log_timezone='UTC'
Restart the database:
$ sudo systemctl reload postgresql-${PGVER?}
See Also
https://dl.dod.cyber.mil/wp-content/uploads/stigs/zip/U_CD_Postgres_16_V1R2_STIG.zip
Item Details
Category: AUDIT AND ACCOUNTABILITY
References: 800-53|AU-8b., CAT|II, CCI|CCI-001890, Rule-ID|SV-261921r1000994_rule, STIG-ID|CD16-00-007500, Vuln-ID|V-261921
Plugin: PostgreSQLDB
Control ID: 7d5bf4b562b0b0c74b3d9affae645359890ff0199ba0c5be98feafdc7f6a3193