CODEWITHSUNDEEP
timescaledb
begginerABD
begginerABD

Reputation: 11

Timescaledb update FATAL: extension "timescaledb" version mismatch: shared library version 1.6.1; SQL version 1.4.2

Server has 3 databases with timescaledb 2 updated well but 3 have error

psql -p 5433 -X -d rates
rates=# ALTER EXTENSION timescaledb UPDATE;
ERROR:  extension "timescaledb" version mismatch: shared library version 1.6.1; SQL version 1.4.2
CONTEXT:  parallel worker

show version tsdb on current database

SELECT default_version, installed_version FROM pg_available_extensions WHERE name = 'timescaledb';

 default_version | installed_version
-----------------+-------------------
 1.6.1           | 1.4.2

Upvotes: 0

Views: 1641

Answers (2)

k_rus
k_rus

Reputation: 3219

According to the release notes of 1.5.0 version, which is on the update path between 1.4.2 and 1.6.1, it is necessary to restart the instance before doing the update. From the release notes:

For this release only, you will need to restart the database before running ALTER EXTENSION.

Upvotes: 0

begginerABD
begginerABD

Reputation: 11

max_parallel_workers = 0

in postgresql.conf and reload config postgresq;

Upvotes: 1

Related Questions