Share via

Azure Database for PostgreSQL REST API

The Azure Database for PostgreSQL management API provides create, read, update, and delete functionality for Azure PostgreSQL resources including servers, databases, firewall rules, network configuration, security alert policies, log files and configurations with new business model.

Azure Database for PostgreSQL provides a managed database service for application development and deployment that allows you to stand up a PostgreSQL database in minutes and scale on the fly - on the cloud you trust most.

The following information is common to all tasks that you might do using these REST APIs:

  • Replace {api-version} with the latest available stable API version, such as 2024-08-01, if you plan to use functionality which is generally available. Or with the latest available preview version such as 2024-11-01-preview, in case you plan to use functionality which is still in preview and hasn't transitioned to general availability. Find the list of stable and preview versions published so far.
  • Replace {subscriptionId} with the identifier of the subscription identifier in the URI. This value is a Globally Unique Identifier assigned to your subscription, such as aaaa0a0a-bb1b-cc2c-dd3d-eeeeee4e4e4e. Locate the subscription identifier using Azure portal subscriptions blade.
  • Replace {resourceGroupName} with the name of the resource group. For more information, see Use the Azure portal and Azure Resource Manager to manage resource groups.
  • Replace {serverName} with the name of your Azure Database for PostgreSQL server.
  • For any other entities like backupName, firewallRuleName, objectId, targetDbServerName, etc., read through the documentation of the specific API which uses them, and the examples referenced in that documentation.
  • Set the Content-Type header to application/json.
  • Set the Authorization header to a JSON Web Token that you obtain from Microsoft Entra ID service. For more information, see Getting Started with Azure REST.

See also