CIS PostgreSQL 12 DB v1.0.0

Warning! Audit Deprecated

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

View Next Version

Audit Details

Name: CIS PostgreSQL 12 DB v1.0.0

Updated: 7/11/2023

Authority: CIS

Plugin: PostgreSQLDB

Revision: 1.1

Estimated Item Count: 47

File Details

Filename: CIS_PostgreSQL_12_v1.0.0_L1_Database.audit

Size: 120 kB

MD5: 77c18200583f6f2e1fcfbd1036f91840
SHA256: bd9b73376f1d1b132b58260a3c4a831ed622288126e36319c6cdc66ee13f9483

Audit Items

DescriptionCategories
3.1.2 Ensure the log destinations are set correctly
3.1.3 Ensure the logging collector is enabled
3.1.4 Ensure the log file destination directory is set correctly
3.1.5 Ensure the filename pattern for log files is set correctly
3.1.6 Ensure the log file permissions are set correctly
3.1.7 Ensure 'log_truncate_on_rotation' is enabled
3.1.8 Ensure the maximum log file lifetime is set correctly
3.1.9 Ensure the maximum log file size is set correctly
3.1.10 Ensure the correct syslog facility is selected
3.1.11 Ensure the program name for PostgreSQL syslog messages is correct
3.1.12 Ensure the correct messages are written to the server log
3.1.13 Ensure the correct SQL statements generating errors are recorded
3.1.14 Ensure 'debug_print_parse' is disabled
3.1.15 Ensure 'debug_print_rewritten' is disabled
3.1.16 Ensure 'debug_print_plan' is disabled
3.1.17 Ensure 'debug_pretty_print' is enabled
3.1.18 Ensure 'log_connections' is enabled
3.1.19 Ensure 'log_disconnections' is enabled
3.1.20 Ensure 'log_error_verbosity' is set correctly
3.1.21 Ensure 'log_hostname' is set correctly
3.1.22 Ensure 'log_line_prefix' is set correctly
3.1.23 Ensure 'log_statement' is set correctly
3.1.24 Ensure 'log_timezone' is set correctly
3.2 Ensure the PostgreSQL Audit Extension (pgAudit) is enabled - pgaudit installed
3.2 Ensure the PostgreSQL Audit Extension (pgAudit) is enabled - show pgaudit.log
4.2 Ensure excessive administrative privileges are revoked
4.3 Ensure excessive function privileges are revoked
4.4 Ensure excessive DML privileges are revoked
4.5 Use pg_permission extension to audit object permissions
4.6 Ensure Row Level Security (RLS) is configured correctly
4.7 Ensure the set_user extension is installed
4.8 Make use of default roles
6.1 Ensure 'Attack Vectors' Runtime Parameters are Configured
6.2 Ensure 'backend' runtime parameters are configured correctly
6.3 Ensure 'Postmaster' Runtime Parameters are Configured
6.4 Ensure 'SIGHUP' Runtime Parameters are Configured
6.5 Ensure 'Superuser' Runtime Parameters are Configured
6.6 Ensure 'User' Runtime Parameters are Configured
6.8 Ensure SSL is enabled and configured correctly
6.9 Ensure the pgcrypto extension is installed and configured correctly
7.1 Ensure a replication-only user is created and used for streaming replication
7.2 Ensure base backups are configured and functional
7.4 Ensure streaming replication parameters are configured correctly
8.1 Ensure PostgreSQL configuration files are outside the data cluster
8.2 Ensure PostgreSQL subdirectory locations are outside the data cluster
8.4 Ensure miscellaneous configuration settings are correct
CIS_PostgreSQL_12_v1.0.0_L1_DB.audit from CIS PostgreSQL 12 Benchmark v1.0.0