PGROUTING extension fails to deploy when added to postgres 16

Hi Christian Shardey,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

Although pgRouting was recently added to the extension list for PostgreSQL 16, the error occurs because Azure Database for PostgreSQL Flexible Server requires extensions to be allowlisted and fully supported in the managed environment. Even if the extension appears in documentation, deployment can fail if:

• The extension binaries are not yet available in the Azure-managed image.
  Try checking the supported extension using SELECT * FROM pg_available_extensions WHERE name = 'pgrouting'; If the extension appears but has a NULL or empty version, it means the binary is not yet installed on that image.
• The extension is not properly allowlisted in the azure.extensions parameter.
  Follow Microsoft Learn: https://free.blessedness.top/en-us/azure/postgresql/extensions/how-to-allow-extensions?tabs=allow-extensions-portal

I hope this information is helpful! If you still have questions or you come across issues, please let us know what is needed in the comments so this question can be answered.

Thanks,

Abhisek

Hi Christian Shardey,

I hope you had a chance to review the information shared earlier, and I hope this information has been helpful! If you still have questions, please let us know what is needed in the comments so the question can be answered.

Thanks,

Abhisek