Enable "LOG_CHECKPOINTS" Parameter for PostgreSQL Servers

Sign in to Azure Management Console.

Navigate to All resources blade at https://portal.azure.com/#blade/HubsExtension/BrowseAll to access all your Microsoft Azure resources.

From the Type filter box, select Azure Database for PostgreSQL server to list the PostgreSQL servers available within your Azure account.

Click on the name of the PostgreSQL database server that you want to examine.

In the navigation panel, under Settings, select Server parameters to access the configuration parameters for the selected PostgreSQL server.

On Server parameters page, find the log_checkpoints parameter entry using the Search to filter items search box. Once the parameter entry is found, check its configuration value available within the VALUE column. If the parameter value is set to OFF, the "log_checkpoints" server parameter is not enabled for the selected PostgreSQL database server.

Repeat steps no. 4 – 6 for each PostgreSQL database server provisioned in the current Azure subscription.

Repeat steps no. 3 – 7 for each subscription created in your Microsoft Azure cloud account.

Run postgres server list command (Windows/macOS/Linux) using custom query filters to list the names of all PostgreSQL database servers (and the name of their associated resource groups) available in the current Azure subscription:

az postgres server list
	--output table
	--query '[*].{name:name, resourceGroup:resourceGroup}'

The command output should return a table with requested PostgreSQL server information:

Name                ResourceGroup
------------------  ------------------------------
cc-project5-server  cloud-shell-storage-westeurope

Run postgres server configuration show command (Windows/macOS/Linux) using the name of the Azure PostgreSQL server that you want to examine and its associated resource group as identifier parameters with custom query filters to get the "log_checkpoints" parameter value for the selected database server:

az postgres server configuration show
	--server-name "cc-project5-server"
	--resource-group "cloud-shell-storage-westeurope"
	--name log_checkpoints
	--query 'value'

The command output should return the requested configuration value:

"OFF"

If postgres server configuration show command output returns "OFF", as shown in the example above, the "log_checkpoints" server parameter is not enabled for the selected Azure PostgreSQL database server.

Repeat step no. 3 and 4 for each Azure PostgreSQL server available in the selected subscription.

Repeat steps no. 1 – 5 for each subscription available within your Microsoft Azure cloud account.

Sign in to Azure Management Console.

Navigate to All resources blade at https://portal.azure.com/#blade/HubsExtension/BrowseAll to access all your Microsoft Azure resources.

From the Type filter box, select Azure Database for PostgreSQL server to list the PostgreSQL servers available in your Azure account.

Click on the name of the PostgreSQL server that you want to reconfigure (see Audit section part I to identify the right Azure resource).

In the navigation panel, under Settings, select Server parameters to access the configuration parameters for the selected PostgreSQL server.

On Server parameters page, find the log_checkpoints parameter entry using the Search to filter items search box.

Once log_checkpoints server parameter entry is found, enable the parameter by selecting the ON configurable value, available within the VALUE column.

Click Save to apply the configuration changes.

Repeat steps no. 4 – 8 for each PostgreSQL database server provisioned in the selected subscription.

Repeat steps no. 3 – 8 for each subscription created in your Microsoft Azure cloud account.

Run postgres server configuration set command (Windows/macOS/Linux) using the name of the PostgreSQL server that you want to reconfigure as identifier parameter (see Audit section part II to identify the right Azure resource) to enable "log_checkpoints" parameter for the selected Azure PostgreSQL database server:

az postgres server configuration set
	--server-name "cc-project5-server"
	--resource-group "cloud-shell-storage-westeurope"
	--name log_checkpoints
	--value on

The command output should return the metadata for the reconfigured server parameter:

{
  "allowedValues": "on,off",
  "dataType": "Boolean",
  "defaultValue": "on",
  "description": "Logs each checkpoint.",
  "id": "/subscriptions/abcdabcd-abcd-1234-abcd-abcdabcdabcd/resourceGroups/cloud-shell-storage-westeurope/providers/Microsoft.DBforPostgreSQL/servers/cc-project5-server/configurations/log_checkpoints",
  "name": "log_checkpoints",
  "resourceGroup": "cloud-shell-storage-westeurope",
  "source": "user-override",
  "type": "Microsoft.DBforPostgreSQL/servers/configurations",
  "value": "on"
}

Repeat step no. 1 and 2 for each PostgreSQL database server available in the selected subscription.

Repeat steps no. 1 – 3 for each subscription created within your Microsoft Azure cloud account.