TimescaleDB upgrade fails with “could not load link library” error

[Katha]

Issue

When attempting to upgrade TimescaleDB from version 2.27.0 to 2.28.0 (or 2.28.1) on PostgreSQL 18.0, the upgrade process fails with the following error:

ERROR: could not load link library "C:/Program Files/PostgreSQL/18/lib/timscaledb-2.28.0.dll".The specified procedure could not be found.

CONTEXT: SQL statement:"SET LOCAL search_path TO pg_catalog,pg_temp" link script file"timescaledb--2.27.0--2.28.0.sql",near line 6​

Product Line

EcoStruxure Building Operation

Environment

External Log Storage using PostgreSQL v 18.0

Cause

The failure occurs due to a binary incompatibility between PostgreSQL 18.0 and the TimescaleDB 2.28.x extension build.
The extension was compiled against a newer PostgreSQL version, resulting in missing or incompatible library procedures when loaded on PostgreSQL 18.0. This leads to the “could not load link library” error during the upgrade.

Resolution

Upgrade PostgreSQL from version 18.0 to 18.4 to ensure compatibility with the TimescaleDB 2.28.x extension.

PostgreSQL 18.4 includes the required library compatibility for the extension, allowing the upgrade process to complete successfully.

Steps:

1. Upgrade the PostgreSQL installation from version 18.0 to 18.4.
2. Restart the PostgreSQL service after the upgrade.
3. Re-run the TimescaleDB extension upgrade to version 2.28.x.

Validation:

• Confirm the extension upgrade completes without errors.

  

• Check that External Log Storage is functioning and logs are being written correctly.