CODEWITHSUNDEEP
postgresqltimescaledbpg-upgrade
Nitesh Kumar Anand
Nitesh Kumar Anand

Reputation: 621

postgresql with timescale upgrade

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.

Upvotes: 3

Views: 1285

Answers (2)

Burcin
Burcin

Reputation: 985

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.

Upvotes: 0

Nitesh Kumar Anand
Nitesh Kumar Anand

Reputation: 621

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.

Upvotes: 3

Related Questions