Retension policy and compression not supported for apache license

Manisha Balid 20

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?"

Nikhil Duserla 4,440 Reputation points Microsoft Vendor

2025-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

Hi @Nikhil Dureja

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.
Mahesh Kurva 2,750 Reputation points Microsoft Vendor

2025-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,750 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

Hi @Mahesh Kurva

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

HI @Mahesh Kurva

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,750 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.

1 answer

Mahesh Kurva 2,750 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, and timescaledb are 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

https://www.timescale.com/forum/t/upgrade-your-license-to-timescale-to-use-this-free-community-feature/677

Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please sign in to rate this answer.
Mahesh Kurva 2,750 Reputation points Microsoft Vendor

2025-02-14T17:48:35.5566667+00:00

Hi @Manisha Balid,

Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Manisha Balid 20 Reputation points

2025-02-19T11:43:22.8266667+00:00

Hi @Mahesh Kurva

It's not working we tried but still having issue

Mahesh Kurva 2,750 Reputation points Microsoft Vendor

2025-02-20T07:57:50.3133333+00:00

Hi @Manisha Balid,

Apologies for the inconvenience.

Could you please confirm if you're encountering the same error or if it's a different issue? Additionally, could you provide more details about the error you're seeing?

Manisha Balid 20 Reputation points

2025-02-20T15:14:58.23+00:00

Hi @Mahesh Kurva

Facing same 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

Also not supported compress policy

Mahesh Kurva 2,750 Reputation points Microsoft Vendor

2025-02-21T08:42:25.1133333+00:00

Hi @Manisha Balid,

Here are a few alternative approaches you can consider:

You can create manual backups of your PostgreSQL databases and store them in Azure Blob Storage. This method offers long-term and low-cost object storage.

For more information, please refer the document: https://bobcares.com/blog/azure-postgresql-backup-long-term-retention/

You can automate backups from your Azure Database for PostgreSQL server to Azure Storage for long-term retention. This involves using a Virtual Machine to run backup scripts and store the backups in Azure Storage.

For more information, please refer the document: https://techcommunity.microsoft.com/blog/adforpostgresql/automate-backups-from-azure-database-for-postgresql-server-to-azure-storage-for-/1868466

I hope this information helps. Please do let us know if you have any further queries.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Retension policy and compression not supported for apache license

1 answer

Your answer