@ShaktiSingh-MSFT thanks for detailed description. For Shure I will try first solution and get back to you.
Thanks again.
Boris
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Using Azure Database for PostgreSQL flexible server, version 14 with the TimescaleDB extension version 2.10.0. We are planning to perform an in-place upgrade to PostgreSQL version 15. According to Azure documentation, TimescaleDB version 2.10.0 is compatible with PostgreSQL 15, but not with PostgreSQL 16.
Our problem is that when we attempt to upgrade to version 15, we receive an error indicating that the TimescaleDB extension does not support the upgrade. We found on the Microsoft page that in-place upgrades are not supported (https://video2.skills-academy.com/en-us/azure/postgresql/flexible-server/concepts-major-version-upgrade).
Is there any other solution to perform upgrade without a lengthy pg_dump and pg_restore process? Our database is over 100 GB, and using pg_dump and pg_restore would take approximately a week and is not acceptable because of our SLA to our customers.
@ShaktiSingh-MSFT thanks for detailed description. For Shure I will try first solution and get back to you.
Thanks again.
Boris