postgresql with timescale upgrade

user_1628109 0
Viewed 619

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.

pg-upgrade timescaledb postgresql
2 Answers

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.

user_16281090

You can find solution here;

Shortly, upgrade your postgres version which supports your current timescale version. After that upgrade your timecale to highest supported version with your new postgresql.

If this final version is not your desired version so repeat above.

user_4326050
Related