TimescaleDB on Azure PostgreSQL v16

Daniel Siviter 20 Reputation points
2024-02-16T15:23:42.6633333+00:00

Is it possible to run TimescaleDB on Azure PostgreSQL v16? I just tried and the options in shared_preload_libraries and azure.extensions are not there. Downgrading to v15 works. I assume it due to TimescaleDB only fairly recently supporting it (v2.13.0 on 2023-11-28) and Azure have not integrated yet. Therefore, is there an ETA?

Azure Database for PostgreSQL
0 comments No comments
{count} votes

Accepted answer
  1. Oury Ba-MSFT 16,636 Reputation points Microsoft Employee
    2024-02-16T16:50:55.17+00:00

    @Daniel Siviter

    Thank you for reaching out.

    You mentioned that you tried running TimescaleDB on v16, but the necessary options (shared_preload_libraries and azure.extensions) were not available. Please see below doc for reference.

    https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-extensions#how-to-use-postgresql-extensions

    User's image

    Pleased don't forget to mark as accept answer if the reply was helpful.

    Regards,

    Oury


2 additional answers

Sort by: Most helpful
  1. Oury Ba-MSFT 16,636 Reputation points Microsoft Employee
    2024-02-16T20:32:32.2633333+00:00

    @Daniel Siviter
    Please see link below and screen shot. It is documented. User's image

    https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-extensions#timescaledb Hope that answers your question. Please let me know if you have any questions. I will appreciate if you could rate your feedback again. Regards, Oury

    1 person found this answer helpful.
    0 comments No comments

  2. Rahul Randive 8,671 Reputation points Microsoft Employee
    2024-02-16T16:52:43.64+00:00

    Hi @Daniel Siviter
    I believe currently, there is no other way to use the community edition of the TimescaleDB extension on Azure PostgreSQL Flexible Server, as it supports the Apache version. The only viable option going would be to build own VM to make use of the community license. We only support free version of timescale under apache license. Community version is under proprietary TSL (timescale license) and outside of timescale itself isn't supported by public cloud vendors.  As of now there is no plans to support proprietary licensed extensions as stated in docs. more on licensing - Timescale Documentation | Compare TimescaleDB editions. Hope that helps. Thank you!