Timescaledb-2.18.2.so and postgres 16.4

TimescaleDB and PostgreSQL Installation, Configuration, and Errors
1

Hello,

I am getting the following error when i try to create the timescale 2.18.2 extension on a postgres database v16.4
ERROR: could not load library “/usr/pgsql-16/lib/timescaledb-2.18.2.so”: /usr/pgsql-16/lib/timescaledb-2.18.2.so: undefined symbol: SearchSysCacheLockedCopy1

The library is there, is there a compatibility error?
i am on Rocky Linux release 8.10 (Green Obsidian)

Regards,

2

When we build the extension packages we build against the most recent postgres version at that time. There is no guarantee of backward compatibility only forward compatibility. The symbol in the error message is present in PG16.5 and onward so you need to update your postgres version to at least that version.

1 Like
3

I first upgraded to PG16.5 and that was giving another error (extension “timescaledb” does not support postgres version 16.5) . Then I moved to PG16.6 and that worked.
Thanks for the quick reply and resolution. :pray: