Share via

Unable to Enable pg_cron on Azure PostgreSQL Flexible Server (v16.9) – InternalServerError (Deployment to resource group 'rg-az-prod' failed.)

Niket Kumar Singh 840 Reputation points
2025-07-28T09:29:01.98+00:00

Hi Community,

I'm encountering a consistent issue when trying to enable the pg_cron extension on my Azure Database for PostgreSQL Flexible Server running PostgreSQL version 16.9.

Environment Configuration:

  • PostgreSQL Version: 16.9
  • Compute Tier: General Purpose
  • vCores: 4 (D4ds_v5)
  • Memory: 16 GiB
  • Storage: 256 GiB Premium SSD
  • High Availability: Enabled (Zone redundant)
  • Region: Central India
  • Storage Autogrow: Enabled
  • Extension: pg_cron is listed under allowed values for azure.extensions

When I try to enable the pg_cron extension by setting:

  
  az postgres flexible-server parameter set \
  --resource-group <my-rg> \
  --server-name <my-server> \
  --name azure.extensions \
  --value pg_cron

I get the following error:

  
  (InternalServerError) An unexpected error occurred while processing the request. 
Tracking ID: 'c335c294-2fff-48b1-97df-96a6ab371aec'
  
  

error occurs via Azure Portal UI
User's image

Azure CLI and Portal both fail.

Rechecked all provisioning constraints.

  • Confirmed that this is a known issue as acknowledged by Microsoft in several Q&A threads: https://learn.microsoft.com/en-us/answers/questions/2121382/
      [https://learn.microsoft.com/en-us/answers/questions/2245270/](https://learn.microsoft.com/en-us/answers/questions/2245270/)
    
         - [https://feedback.azure.com/d365community/idea/d4d38b86-0a70-ee11-a81c-000d3ae5ae95](https://feedback.azure.com/d365community/idea/d4d38b86-0a70-ee11-a81c-000d3ae5ae95)
    
         Can anyone confirm if this issue is still ongoing for PG v16.9 Flexible Server in Central India?
    
         If anyone has had success recently enabling `pg_cron` on PG16+, please share the workaround or steps you followed.
    
         Thanks in advance!
    
Azure Database for PostgreSQL

Answer accepted by question author

Saraswathi Devadula 16,025 Reputation points Microsoft External Staff Moderator
2025-07-29T18:20:54.0866667+00:00

Hello Niket Kumar Singh

Initially, you're unable to enable the extension on one server, while it works successfully on another server with the same configuration.

In further analysis, we attempted to disable and enable the HA of the server due to the storage space full, and you were able to add the extension successfully.

Was this answer helpful?

1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.