Plugin Title | Log Disconnections Enabled |
Cloud | AZURE |
Category | PostgreSQL Server |
Description | Ensures disconnection logs are enabled for PostgreSQL servers |
More Info | Disconnection logs ensure all attempted and successful disconnections from the server are logged. |
AZURE Link | https://docs.microsoft.com/en-us/azure/postgresql/howto-configure-server-parameters-using-portal |
Recommended Action | Ensure the server parameters for each PostgreSQL server have the log_disconnections setting enabled. |
- Log into the Microsoft Azure Management Console.
- Select the "Search resources, services, and docs" option at the top and search for PostgreSQL.
- On the "Azure Database for PostgreSQL servers" page, select the database by clicking on the "Name" as a link that needs to be examine.
- Scroll down the left navigation panel and choose "Server parameters" under "Settings."
- On the "Server parameters" page, search for "log_disconnections" paramter using the "Search for filter item search box." If the value is set to "OFF" then the "log-disconnections" is not enabled for PostgreSQL servers.
- Repeat steps number 2 - 5 to verify other "PostgreSQL" databases in the account.
- Navigate to "PostgreSQL", select the database by clicking on the "Name" and choose "Server parameters" under "Settings" from the left navigation panel.
- On "Server Parameter" page, search for "log_disconnections" paramter using the "Search for filter item search box" and enable it by selecting "ON" from the toggle configuration button.
- Click on the "Save" button at the top to make the changes.
- Repeat steps number 7 - 9 to ensure the server parameters for each PostgreSQL server have the log_disconnections setting enabled.