Extension "timescaledb" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL (Flexible)

Question

I followed this guide for enabling TimescaleDB for Azure Database for PostgreSQL Flexible (PostgreSQL 14):

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

The following sites also lists its as available:
https://learn.microsoft.com/de-de/azure/postgresql/single-server/concepts-extensions

But after adding it to libs an restarting I get the following error when I try to add the extension in Postgres:

ERROR: extension "timescaledb" is not allow-listed for "azure_pg_admin" users in Azure Database for PostgreSQL

How can I fix that?

(For now I am using old single server variant but this only has PostgreSQL 11 with old TimescalDB version)

Answer 1

Hi, @Jonas Welcome to the Microsoft Q&A forum, Thanks for posting your question and for using Azure services.
As we understand the ask here is you are trying to enable timescaledDB for PostgreSQL Flexible (PostgreSQL 14) and you are receiving the error
I think that you have added shared_preload_libraries,however, you also need to add the timescaledb under server parameters search for azure.extensions as shown below

Once this is added connect to your database and run the query

Please let me know if you need any additional information.

Regards
Geetha