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_0Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run gcp_compliance.control.sql_instance_postgresql_log_temp_files_database_flag_0 --shareSQL
This control uses a named query:
sql_instance_postgresql_log_temp_files_database_flag_0