TimescaleDB Docker upgrade: could not access file "$libdir/timescaledb-X.Y.Z"

After upgrading the TimescaleDB Docker image, every query fails with ERROR: could not access file "$libdir/timescaledb-1.4.0": No such file or directory, even after ALTER EXTENSION timescaledb UPDATE; says the extension is up to date. The extension binary is pinned to the version it was installed with, and the newer image's library set changed. Early images were also just missing the .so files, which was fixed by pulling the rebuilt image.

Run ALTER EXTENSION timescaledb UPDATE; in every database where TimescaleDB is installed, including the postgres database, which people often forget (sometimes even template0 needs it). If you are jumping several versions at once, do transitional upgrades. The Docker images only ship the last ~5 minor versions' .so files. Source: https://github.com/timescale/timescaledb/issues/1425

Source: https://github.com/timescale/timescaledb/issues/1425