PostgreSQL Log Hostname Flag Should Be On
More Info:
Logging hostnames allows for the association of hostname to IP address at the time of connection. This information can aid with incident response efforts particularly in an environment that utilized dynamic IP addresses. Logging hostnames may incur overhead on server performance as for each statement logged, DNS resolution will be required to convert IP address to hostname. Depending on the setup, this may be non-negligible. This recommendation is applicable to PostgreSQL database instances.Risk Level
LowAddress
Reliability, SecurityCompliance Standards
CISGCP, CBPTriage and Remediation
Remediation
Using Console
Using Console
To remediate the PostgreSQL Log Hostname Flag Should Be On misconfiguration for GCP using GCP console, please follow the below steps:
- Open the Google Cloud Console and select the project containing the PostgreSQL instance.
- In the left navigation menu, select “SQL” to open the Cloud SQL instances page.
- Select the PostgreSQL instance for which you want to remediate the misconfiguration.
- Click on the “Edit” button at the top of the page to open the instance settings.
- Scroll down to the “Flags” section and click on “Add item”.
- In the “Name” field, enter “log_hostname” and in the “Value” field, enter “on”.
- Click on the “Save” button to save the changes.
- Wait for the changes to be applied. This may take a few minutes.
- Once the changes are applied, verify that the PostgreSQL Log Hostname Flag is now turned on by checking the PostgreSQL logs.
Using CLI
Using CLI
To remediate the PostgreSQL Log Hostname Flag Should Be On misconfiguration for GCP using GCP CLI, you can follow the below steps:Step 1: Open the Cloud Shell in your GCP console.Step 2: Run the below command to set the log_hostname flag to on for the PostgreSQL instance:Note: Replace [INSTANCE_NAME] with the name of your PostgreSQL instance.Step 3: Verify the configuration change by running the below command:Note: Replace [INSTANCE_NAME] with the name of your PostgreSQL instance.This command should return the output “log_hostname: on” which indicates that the flag has been set to on.Step 4: Repeat the above steps for all the PostgreSQL instances in your GCP project to ensure that the misconfiguration is remediated.By following the above steps, you can remediate the PostgreSQL Log Hostname Flag Should Be On misconfiguration for GCP using GCP CLI.
Using Python
Using Python
To remediate the PostgreSQL Log Hostname Flag Should Be On misconfiguration in GCP using Python, you can follow these steps:Note: Replace
- Create a service account with the necessary permissions to access the PostgreSQL instance.
-
Install the
google-cloud-sqllibrary using pip. -
Use the following Python code to update the PostgreSQL instance configuration to enable the
log_hostnameflag:
your-project-id, your-instance-name, and your-config-name with your actual values. Also, replace path/to/credentials.json with the path to your service account credentials file.This code will update the PostgreSQL instance configuration to enable the log_hostname flag.