In brief:
I’m trying to find the best path to upgrade from 1.7.5 on PG12 to latest 2.10.x on PG15, in place with a significant volume of data (Zabbix).
Looking at the table here - Timescale Documentation | Upgrade PostgreSQL, it looked like jumping to timescale 2.10.x first, and then doing the PG upgrade second might be the easiest path, but the test upgrade failed with the following error
“ERROR: function _timescaledb_internal.ping_data_node(name) does not exist”
Firstly, is my reading of the table correct, is this a sensible route to take?
Secondly, Can anyone point me in the direction of why the upgrade might be failing?
Many thanks!
TimescaleDB version: 1.7.5
PostgreSQL version: 12.14
OS: Debian
Install method: DEB