PostgreSQLManagementClient
The Microsoft Azure management API provides create, read, update, and delete functionality for Azure PostgreSQL resources including servers, databases,…
Fork copies the collection into your workspace, without the publisher's secrets, so you can add your own key and send requests. Star saves it to your starred APIs (Account › Marketplace) and helps others find it.
Overview
The Microsoft Azure management API provides create, read, update, and delete functionality for Azure PostgreSQL resources including servers, databases, firewall rules, VNET rules, security alert policies, log files and configurations with new business model.
Endpoints 33
Operations
- GETOperations_List
/providers/Microsoft.DBforPostgreSQL/operations?api-version=stringLists all of the available REST API operations.
CheckNameAvailability
- POSTCheckNameAvailability_Execute
/subscriptions/:subscriptionId/providers/Microsoft.DBforPostgreSQL/checkNameAvailability?api-version=stringCheck the availability of name for resource
LocationBasedPerformanceTier
- GETLocationBasedPerformanceTier_List
/subscriptions/:subscriptionId/providers/Microsoft.DBforPostgreSQL/locations/:locationName/performanceTiers?api-version=stringList all the performance tiers at specified location in a given subscription.
Servers
- GETServers_List
/subscriptions/:subscriptionId/providers/Microsoft.DBforPostgreSQL/servers?api-version=stringList all the servers in a given subscription. - GETServers_ListByResourceGroup
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers?api-version=stringList all the servers in a given resource group. - GETServers_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName?api-version=stringGets information about a server. - PUTServers_Create
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName?api-version=stringCreates a new server, or will overwrite an existing server. - DELETEServers_Delete
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName?api-version=stringDeletes a server. - PATCHServers_Update
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName?api-version=stringUpdates an existing server. The request body can contain one to many of the properties present in the normal server definition.
ServerAdministrators
- GETServerAdministrators_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/Administrators/activeDirectory?api-version=stringGets information about a AAD server administrator. - PUTServerAdministrators_CreateOrUpdate
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/Administrators/activeDirectory?api-version=stringCreates or update active directory administrator on an existing server. The update action will overwrite the existing administrator. - DELETEServerAdministrators_Delete
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/Administrators/activeDirectory?api-version=stringDeletes AAD Administrator. - GETServerAdministrators_ListByServer
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/administrators?api-version=stringReturns a list of server Administrators.
Replicas
- GETReplicas_ListByServer
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/Replicas?api-version=stringList all the replicas for a given server.
Configurations
- GETConfigurations_ListByServer
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/configurations?api-version=stringList all the configurations in a given server. - GETConfigurations_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/configurations/:configurationName?api-version=stringGets information about a configuration of server. - PUTConfigurations_CreateOrUpdate
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/configurations/:configurationName?api-version=stringUpdates a configuration of a server.
Databases
- GETDatabases_ListByServer
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/databases?api-version=stringList all the databases in a given server. - GETDatabases_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/databases/:databaseName?api-version=stringGets information about a database. - PUTDatabases_CreateOrUpdate
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/databases/:databaseName?api-version=stringCreates a new database or updates an existing database. - DELETEDatabases_Delete
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/databases/:databaseName?api-version=stringDeletes a database.
FirewallRules
- GETFirewallRules_ListByServer
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/firewallRules?api-version=stringList all the firewall rules in a given server. - GETFirewallRules_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/firewallRules/:firewallRuleName?api-version=stringGets information about a server firewall rule. - PUTFirewallRules_CreateOrUpdate
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/firewallRules/:firewallRuleName?api-version=stringCreates a new firewall rule or updates an existing firewall rule. - DELETEFirewallRules_Delete
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/firewallRules/:firewallRuleName?api-version=stringDeletes a server firewall rule.
LogFiles
- GETLogFiles_ListByServer
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/logFiles?api-version=stringList all the log files in a given server.
ServerRestart
- POSTServers_Restart
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/restart?api-version=stringRestarts a server.
ServerSecurityAlertPolicies
- GETServerSecurityAlertPolicies_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/securityAlertPolicies/:securityAlertPolicyName?api-version=stringGet a server's security alert policy. - PUTServerSecurityAlertPolicies_CreateOrUpdate
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/securityAlertPolicies/:securityAlertPolicyName?api-version=stringCreates or updates a threat detection policy.
VirtualNetworkRules
- GETVirtualNetworkRules_ListByServer
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/virtualNetworkRules?api-version=stringGets a list of virtual network rules in a server. - GETVirtualNetworkRules_Get
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/virtualNetworkRules/:virtualNetworkRuleName?api-version=stringGets a virtual network rule. - PUTVirtualNetworkRules_CreateOrUpdate
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/virtualNetworkRules/:virtualNetworkRuleName?api-version=stringCreates or updates an existing virtual network rule. - DELETEVirtualNetworkRules_Delete
/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/virtualNetworkRules/:virtualNetworkRuleName?api-version=stringDeletes the virtual network rule with the given name.
API details
- Base URL
https://management.azure.com- Authentication
- OAuth 2.0 (implicit flow) with 1 scope
- Operations
- 33 operations on 20 pathsGET 18PUT 7DELETE 5POST 2PATCH 1
- Main resources
- Servers 6Databases 4FirewallRules 4ServerAdministrators 4VirtualNetworkRules 4Configurations 3ServerSecurityAlertPolicies 2CheckNameAvailability 1LocationBasedPerformanceTier 1LogFiles 1
- Response formats
application/json- Description format
- Swagger 2.0, API version
2017-12-01-preview - Links
- OpenAPI document
- Listed from
- APIs.guru OpenAPI Directory (CC0-1.0)
Source updated
How to test the PostgreSQLManagementClient in Swastik Codes
- Open the APISelect “Fork & run in Swastik Codes” on this page. Sign in or create a free account if asked.
- Fork it into your workspaceChoose a workspace. You get your own copy of the PostgreSQLManagementClient collection, without the publisher's secrets.
- Add your credentialsThis API uses OAuth 2.0 (implicit flow) with 1 scope. Add yours in the collection's variables or an environment; the requests already reference it.
- Send a requestPick an endpoint, for example “Operations_List” (GET /providers/Microsoft.DBforPostgreSQL/operations?api-version=string), and press Send. Check the response, add tests and run the whole collection with the runner.
Frequently asked questions
What is the PostgreSQLManagementClient?
The Microsoft Azure management API provides create, read, update, and delete functionality for Azure PostgreSQL resources including servers, databases,… It is listed under Developer tools and has 33 endpoints.
Who publishes the PostgreSQLManagementClient?
It is listed from Microsoft Azure's public API description (an OpenAPI document), not published by Microsoft Azure on Swastik Codes. Anyone who controls azure.com can claim the profile by adding a DNS TXT record.
What is the base URL of the PostgreSQLManagementClient?
Requests go to https://management.azure.com. Endpoint paths are added to this base URL.
How do I authenticate with the PostgreSQLManagementClient?
With OAuth 2.0 (implicit flow) with 1 scope.
How many endpoints does the PostgreSQLManagementClient have?
33 operations on 20 paths (18 GET, 7 PUT, 5 DELETE, 2 POST, 1 PATCH). The largest groups are Servers, Databases, FirewallRules, ServerAdministrators.
Is forking the PostgreSQLManagementClient free?
Yes. Forking copies the collection into your workspace for free. It has been starred 0 times and forked 0 times.