Enable TimescaleDB for PostgreSQl Flexi server

Question

Hello Azure Support Team,

Could you please confirm if Azure Database for PostgreSQL Flexible Server currently supports installing and running TimescaleDB Community Edition (preferably the latest stable release)? If so, are there any version limitations or special requirements?

Thank you,

Nandhana

Answer 1

Hi Nandhana Pramod Admin | Auro,

Thanks for approaching Microsoft Q&A!

Can you please check the following checks

1. Support for TimescaleDB: Yes, Azure Database for PostgreSQL does support the TimescaleDB extension. You can enable it by using the SQL command:

      CREATE EXTENSION timescaledb;
   

2. Version Limitations: Currently, the supported version of TimescaleDB for Azure Flexible Server is available in the Apache 2.0 edition. If you're looking for the most recent stable release, it's best to check the official TimescaleDB documentation for the latest version that is compatible with Azure.
3. Special Requirements:
   • Allowlisting: You need to ensure the TimescaleDB extension is allowlisted and properly installed in your PostgreSQL database.
   • Configuration: You might want to set server parameters like timescaledb.max_background_workers to optimize its performance.

For detailed instructions on enabling the extension and additional considerations, refer to the following document.

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

I hope this helps, do let us know if you have any questions.

If the provided information helpful, kindly click "Upvote" and "Accept Answer", it will help others who might be facing similar challenges.

Thanks!

Kalyani