| Plugin Title | Log Checkpoints Enabled |
| Cloud | AZURE |
| Category | PostgreSQL Server |
| Description | Ensures log checkpoints are enabled for PostgreSQL servers |
| More Info | Log checkpoints logs queries and errors that arise in the server, enabling faster detection of incidents. |
| 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_checkpoints 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_checkpoints" paramter using the "Search for filter item search box." If the value is set to "OFF" then the log checkpoints are 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_checkpoints" 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_checkpoints setting enabled.
