Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
1,194 questions
Retension policy and compression not supported for apache license
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 50%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Manisha Balid
20
Reputation points
Hi,
I'm encountering an error when trying to create a hypertable with the retention policy and compression features. The error message indicates that the 'Apache' license is not supported. Could you please provide a solution for this issue?"
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 79%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3END%3C/text%3E%3C/svg%3E)
Nikhil Duserla 4,365 Reputation points Microsoft Vendor2025-02-11T09:24:08.8366667+00:00 Hi @Manisha Balid,
Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.
Can you please elaborate on this issue? Let me know if the problem you are facing is related to the database or the virtual machine.
-
Manisha Balid 20 Reputation points
2025-02-11T11:13:31.31+00:00 I am facing issue with database. I am trying to create hyper table under postgresql server, but while creating hypertable with the retention policy and compression commands. The error message indicates that the 'Apache' license is not supported.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva 2,670 Reputation points Microsoft Vendor2025-02-11T12:06:26.1433333+00:00 Hi @Manisha Balid,
Welcome to Microsoft Q&A forum.
Sorry for the inconvenience.
Could you confirm if PostgreSQL is hosted on Azure cloud?
-
Manisha Balid 20 Reputation points
2025-02-11T14:26:26.1066667+00:00 yes, PostgreSQL is hosted on Azure cloud
-
Mahesh Kurva 2,670 Reputation points Microsoft Vendor
2025-02-11T20:40:56.45+00:00 Hi @Manisha Balid,
Thank you for the update!
The issue you're facing with creating a hypertable and applying retention policy and compression. The error message you're encountering indicates that the features you're trying to use are not available under the 'Apache' license.
I recommend referring to the official TimescaleDB installation guide. This guide will help you ensure that the appropriate version of TimescaleDB (with the necessary features) is installed and configured. You can follow the detailed instructions in the link below:
https://docs.timescale.com/self-hosted/latest/install/installation-windows/
I hope this information helps. Please do let us know if you have any further queries.
-
Manisha Balid 20 Reputation points
2025-02-12T07:49:07.0966667+00:00 Any other way to use retention and compress features use under Postgresql on azure
-
Manisha Balid 20 Reputation points
2025-02-12T12:51:16.8433333+00:00 I have already installed postgresql on windows.
https://docs.timescale.com/self-hosted/latest/install/installation-windows/
but still facing issue with add retention policy on PostgreSQL server, any other alternative way to use retention policy??
-
Mahesh Kurva 2,670 Reputation points Microsoft Vendor
2025-02-12T13:07:19.1666667+00:00 Hi @Manisha Balid,
The extensions
anon,Apache AGE,dblink,orafce,pgaudit,postgres_fdw, andtimescaledbare unsupported for all Azure Database for PostgreSQL flexible server versions when using in-place major version update feature.For more information, please refer the document: https://learn.microsoft.com/en-us/azure/postgresql/extensions/concepts-extensions-considerations#timescaledb
Please refer to the links, they might be helpful:
https://github.com/zalando/spilo/issues/645
I hope this information helps. Please do let us know if you have any further queries.
-
Mahesh Kurva 2,670 Reputation points Microsoft Vendor
2025-02-13T17:54:59.3766667+00:00 Hi @Manisha Balid,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Sign in to comment
Sign in to answer