Releases: expaso/hassos-addon-timescaledb
v4.2.0 🌈
Changes
- 🎉 Added
system_stats
extension by default so the pgAdmin dashboard looks more complete. It is not installed by default. You can do that manually as indicated by pgAdmin. Closes #47
v4.1.0 🌈
v4.1.0-RC1 🌈
Changes
- ⬆️ Upgraded PostgreSql to version 16.3
- ⬆️ Upgraded TimescaleDb to version 2.16.1 - Fixes #46
- ⬆️ Upgraded base-images to 16.2.1
v4.0.3 🌈
Changes
- Beta-Release publish of new CI/CD pipeline
v4.0.2
v4.0.1
Changes
- No changes
v4.0.0
About this release
Finally its here! What you all have been waiting for: The TimescaleDB Toolkit Release! 🥳
It has been a long time coming, but I am finally able to release the TimescaleDB Toolkit for all supported architectures. This release includes the latest version of TimescaleDB, PostgreSQL and Postgis.
🚀 Features
- Finally! 🎉 TimescaleDB_Toolkit 1.18.0! (only for amd64/aarch64/arm64 systems, but that would cover most of you). See: https://github.com/timescale/timescaledb-toolkit?tab=readme-ov-file
- PostgreSQL 16.2 -> https://www.postgresql.org/docs/release/16.2/
- TimescaleDB 2.14.2 -> https://docs.timescale.com/about/latest/release-notes/#timescaledb-2142-on-2024-02-20
- Postgis 3.4.2 -> https://postgis.net/docs/release_notes.html
- Support for all architechtures (amd64, aarch64, armv7, armhf, i386).
- Support for running this addon as a standalone docker container outside of Home Assistant! Please consult the readme for more information.
Notes before upgrading
As you are already accustomed to, this release will auto-upgrade your current PostgreSQL 15 installation to PostgreSQL 16.2. This is a major upgrade and you should be aware of the following:
-
PostgreSQL 16.2 is a major version upgrade. This means that you will not be able to downgrade to PostgreSQL 15 without a backup.
-
From Timescale 2.7 onwards, TimescaleDb has a new form of continuous aggregates. If you have continuous aggregates in your database, you should read the following documentation: https://docs.timescale.com/use-timescale/latest/continuous-aggregates/migrate/
TLDR;
Use the following query to see if you have continuous aggregates in your database:
select * from timescaledb_information.continuous_aggregates
Look at the last column 'Finalized'. If it says False, you could migrate the continuous aggregates after upgrading the addon using:
CALL cagg_migrate('<name of aggregate>', true, true);
The query output will hint you that you need to refresh the aggregate using the query specified in the message.
Overthinking
This release was a real pain in the %#@ to get out.
To compile all this stuff in for different architechtures proved non-trivial at best, and hell on earth at worst.
I have had many compiler crashes, demolished WSL2, triggered bugs in qemu, docker, Alpine, even in docker-hub which I had to wait for.
I even had to rewrite all buildscripts to precompile a lot of stuff upfront, otherwise the github build-agents would just give up on me!
But I am happy it finally worked out. I hope you all enjoy this release as much as I did making it (most of the time ;)
Thank you for all your support and your patience. I hope you all have a great time with this release!
I would love to hear your feedback, so please let me know what you think on Github (https://github.com/Expaso/hassos-addon-timescaledb), Discord (https://discord.gg/ceAynsJd), The HA Community (https://community.home-assistant.io/t/home-assistant-add-on-postgresql-timescaledb/) or just buy me a coffee:
Thank you all!
v3.0.2
v3.0.1
v3.0.0
It has been a while, but this release had many many important changes under the hood!
Maintenance:
- ⬆️ Upgraded Postgresql to 15.3 🥳
- ⬆️ Upgraded TimescaleDb to 2.11.1
- ⬆️ Upgraded Postgis to 3.3.3
- ⬆️ Upgraded Base Images to 14.0.2
- ⬆️ Upgraded all S6 container scripts to the new coding style
- ⬆️ Moved all config files from json to yaml
- 🙋🏻♂️ Deprecated i386 and armhf architectures
Features:
- 🚀 Paved the way for Timescaledb-Toolkit integration
- 🚀 Postgresql 14 to Postgresql 15 auto upgrade
- 🚀 Increased max-connections default to 50
- 🚀 Added dependencies for Postgis-raster to fuction
- 🚀 Implemented Codenotary CAS to enable addon-signing for a higher security rating
Fixes:
- 🐛 Fixed an issue whereby pgAgent jobs did not run due to noexec mount of /tmp. Moved the workingfolder of pgAgent to /data/tmp/pgagent