azure-mgmt-postgresqlflexibleservers

import os from azure.identity import DefaultAzureCredential from azure.mgmt.postgresqlflexibleservers import PostgreSQLManagementClient # Set environment variables or ensure Azure CLI is logged in # AZURE_SUBSCRIPTION_ID # AZURE_RESOURCE_GROUP # AZURE_LOCATION # AZURE_SERVER_NAME # AZURE_ADMIN_USERNAME # AZURE_ADMIN_PASSWORD subscription_id = os.environ.get('AZURE_SUBSCRIPTION_ID', 'YOUR_SUBSCRIPTION_ID') resource_group_name = os.environ.get('AZURE_RESOURCE_GROUP', 'my-postgresql-rg') server_name = os.environ.get('AZURE_SERVER_NAME', 'my-flex-server-123') location = os.environ.get('AZURE_LOCATION', 'eastus') # e.g., 'eastus' admin_username = os.environ.get('AZURE_ADMIN_USERNAME', 'psqladmin') admin_password = os.environ.get('AZURE_ADMIN_PASSWORD', 'ComplexP@ssw0rd') # Authenticate using DefaultAzureCredential credential = DefaultAzureCredential() # Create a PostgreSQLManagementClient client = PostgreSQLManagementClient(credential, subscription_id) print(f"Creating PostgreSQL flexible server '{server_name}' in resource group '{resource_group_name}'...") # Create a flexible server # This is an asynchronous operation, use .begin_create() and wait() for completion server_poller = client.servers.begin_create( resource_group_name, server_name, { "location": location, "sku": { "name": "Standard_D2ds_v4", "tier": "GeneralPurpose" }, "properties": { "version": "14", # or "12", "13", "15", etc. "administratorLogin": admin_username, "administratorLoginPassword": admin_password, "storage": { "storageSizeGB": 32 }, "network": { "publicNetworkAccess": "Enabled" } } } ) server = server_poller.result() # Wait for the creation to complete print(f"Server '{server.name}' created successfully in {server.location}.") print(f"Provisioning state: {server.provisioning_state}") # Example: List all servers in the resource group print(f"\nListing servers in resource group '{resource_group_name}':") for s in client.servers.list_by_resource_group(resource_group_name): print(f"- {s.name} ({s.location}) - State: {s.state}") # Note: This quickstart creates a resource. Remember to delete it after use # client.servers.begin_delete(resource_group_name, server_name).wait() # print(f"Server '{server_name}' deleted.")