Hi,
I had Zabbix 5.0 in Centos 7 with postrgresq12 and Timescale 1.7
I created db dump with pg_dump but I DID NOT backup hypertables schema. !! It has size of 15gb in .gz format.
Now I installed new Rocky Linux 9 and installed PostgreSQL in docker. However, during the import, I keep getting hypertables errors (also in psql12 with timescale1.7 and I plan to do an upgrade of DB)
Can someone please provide step-by-step detail how to this?
Or is my database ruined forever without hypertables? Old disk are formatted.
Should I try to import it immediately to timescale 2.10 with Postrgesql 14 and a new instance od Zabbix 6? Will Zabbix automatically reconfigure all information in the database or not?
Im not sure if I can import dump created in timescale 1.7 to 2.10. Is it a problem that I'm trying to import this inside the docker container and before it worked directly on physical server?
Thank you.
I had Zabbix 5.0 in Centos 7 with postrgresq12 and Timescale 1.7
I created db dump with pg_dump but I DID NOT backup hypertables schema. !! It has size of 15gb in .gz format.
Now I installed new Rocky Linux 9 and installed PostgreSQL in docker. However, during the import, I keep getting hypertables errors (also in psql12 with timescale1.7 and I plan to do an upgrade of DB)
Can someone please provide step-by-step detail how to this?
Or is my database ruined forever without hypertables? Old disk are formatted.
Should I try to import it immediately to timescale 2.10 with Postrgesql 14 and a new instance od Zabbix 6? Will Zabbix automatically reconfigure all information in the database or not?
Im not sure if I can import dump created in timescale 1.7 to 2.10. Is it a problem that I'm trying to import this inside the docker container and before it worked directly on physical server?
Thank you.
Comment