Error while restoring a database

TimescaleDB and PostgreSQL
1

Hello,

I just finished restoring a database (PG 14.18 on Ubuntu 20.04 with Timescaledb 2.19.3) and after the restore is done when I do

SELECT timescaledb_post_restore();

I get

ERROR: catalog version mismatch, expected “2.19.3” seen “2.16.1”
CONTEXT: PL/pgSQL function public.timescaledb_post_restore() line 12 at RAISE

How can I get around this error message and finish my restore?

Thanks you very much!

Charles

2

the version used to dump the database and the version used in the restore need to be identical, you cannot mix version upgrade with dump/restore. The database you want to load the dump into needs to have timescaledb 2.16.1