Can you add the postgis extension to an azure flexible server with postgres 16?

Question

Hello,

I am trying to upgrade our Azure Database for PostgreSQL flexible server to use postgres 16 and i need to add the postgis extension. At the moment we do this via a pipeline which adds the extension to azure.extension however this now gives the following error "The value 'postgis' for configuration 'azure.extensions' is not valid. The allowed values are 'the ones indicated by PostgreSQL documentation' ". I tried to read the documentation to find out the equivalent, but there was no documentation on the Azure Database for PostgreSQL flexible server page for version 16 of postgres.

I was wondering if it was possible to add the postgis extension and if so, what it was called now, as it does not appear to be in the azure.extension of the Azure Database for PostgreSQL flexible server for postgres 16. If it is not done this way anymore, what is the recommended way?

Thanks,

Russell.

Answer 1

Hi @Russell Soper Welcome to Microsoft Q&A thanks for posting your question.

We have the documents available until 15 however all the extensions which are available in 15 should be available for 16 as well.

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-extensions#postgres-15-extensions

However, 16 is not listed version yet on official Microsoft Doc

you can also refer the similar ask here https://learn.microsoft.com/en-us/answers/questions/1432093/pg-buffercache-extension-not-available-in-postgres

Regards

Geetha

Answer 2

It looks like now is clearly supported on docs however it still doesn't show on the list

regards

jorge