postgresql with timescale upgrade

Question

I have an installation of Postgresql 9.6.11 with shared library of Timescale 1.1.1 installed. I am trying to upgrade both of them, using in-place upgrade for Timescale and pg_upgrade for Postgres, i.e Postgresql to 11.5 and Timescale to 1.4. Which should I upgrade first? I was successfully able to upgrade Timescale first and then I tried to proceed with pg_upgrade, but I ran into error pg_restore: [archiver (db)] Error from TOC entry 1012; 1259 24224 TABLE cache_inval_extension I am wondering if I should have installed Postgresql 11.5 with Timescale 1.1.1. And then use pg_upgrade and then in-place for timescale.

Answer 1

I learned after trying that you can do it either way. You just need to let timescale know that upgrade is in progress using the command -O "-c timescaledb.restoring='on'" when running pg_upgrade.