Feature Proposal: Add support for PostgreSQL flexible servers

[arahja]

SUMMARY

Add Azure Database for PostgreSQL flexible servers support

ISSUE TYPE

• Currently azure.azcollection.azure_rm_postgresqlserver_info and the other "azure_rm_postgresql" prefixed modules do not list or see the postgresql flexible servers.
• Can support be added to the existing modules for postgresql flexible servers or add new modules to support these servers?
• Azure Database for PostgreSQL flexible servers have recently been made generally available.

COMPONENT NAME

• azure_rm_postgresqlconfiguration
• azure_rm_postgresqlconfiguration_info
• azure_rm_postgresqldatabase
• azure_rm_postgresqldatabase_info
• azure_rm_postgresqlfirewallrule
• azure_rm_postgresqlfirewallrule_info
• azure_rm_postgresqlserver
• azure_rm_postgresqlserver_info

[tschechniker]

+1

[NemoDang]

+1

[sharvarikhedkar]

+1

[MrChips821]

+1

[AlbertoGonzalezMayorga]

+1

[pwakano]

+1 Specially given the single server won't be available for creation from Nov 2023 and is going to be retired in 2025. https://learn.microsoft.com/en-us/azure/postgresql/single-server/whats-happening-to-postgresql-single-server

[anitoshsaha]

[pwakano]

For those interested, a workaround to create the flexible server using the generic azure_rm_resource:

- azure_rm_resource:
    subscription_id: "{{ subscription_id }}"
    resource_group: "{{ resource_group }}"
    provider: DBforPostgreSQL
    resource_type: flexibleServers
    resource_name: "{{ name }}"
    idempotency: true
    api_version: '2021-06-01'
    body: # Ref: https://learn.microsoft.com/en-us/rest/api/postgresql/flexibleserver/servers/create?tabs=HTTP
       location: "{{ location }}"
       sku: "{{ sku }}"
       properties:
          administratorLogin: "{{ admin_username }}"
          administratorLoginPassword: "{{ admin_password }}"
          createMode: Create
          backup:
             geoRedundantBackup: "{{ geo_redundant_backup }}"
          highAvailability:
             mode: "{{ high_availability }}"
          network:
             delegatedSubnetResourceId: "{{ pg_subnet_id }}"
             privateDnsZoneArmResourceId: "{{ pg_dns_zone_id }}"
             publicNetworkAccess: Disabled
          storage:
             storageSizeGB: "{{ storage_size_gb }}"
          version: "{{ version }}"
       tags: "{{ tags }}"

[matt961]

+1

[zph001]

For those interested, a workaround to create the flexible server using the generic azure_rm_resource ...

---

+1

No problem to create a flexible server. The problem is all azure_rm_postgresql* modules don't support it, because Azure has since put flexible servers under the resource path .../flexibleServers/... but these modules only search under .../servers/...

[hoangquy4897]

+1

[bigg01]

+1

[MustafUddinAhmed]

Any updates on this feature?

As today I am not able to get details of my "Azure Database for PostgreSQL flexible servers" using "azure.azcollection.azure_rm_postgresqlserver" collection, which we needs to be supported.

[zph001]

After months, we the Azure customers are still waiting ...

[p3ck]

The following modules are available now:

azure_rm_postgresqlflexibleconfiguration_info.py azure_rm_postgresqlflexibledatabase_info.py azure_rm_postgresqlflexibledatabase.py azure_rm_postgresqlflexiblefirewallrule_info.py azure_rm_postgresqlflexiblefirewallrule.py azure_rm_postgresqlflexibleserver_info.py azure_rm_postgresqlflexibleserver.py

Can this be closed? Thanks!

[Fred-sun]

Closed because of https://github.com/ansible-collections/azure/pull/1192