turbot/gcp_compliance

Control: Ensure that the 'log_temp_files' database flag for Cloud SQL PostgreSQL instance is set to '0'

Description

PostgreSQL can create a temporary file for actions such as sorting, hashing and temporary query results when these operations exceed work_mem. The log_temp_files flag controls logging names and the file size when it is deleted. Configuring log_temp_files to 0 causes all temporary file information to be logged, while positive values log only files whose size is greater than or equal to the specified number of kilobytes. A value of -1 disables temporary file information logging.

Usage

Run the control in your terminal:

powerpipe control run gcp_compliance.control.sql_instance_postgresql_log_temp_files_database_flag_0

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run gcp_compliance.control.sql_instance_postgresql_log_temp_files_database_flag_0 --share

SQL

This control uses a named query:

sql_instance_postgresql_log_temp_files_database_flag_0

Tags