Ad Widget

Collapse

Timescale backup and upgrade

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • confusedd
    Junior Member
    • Oct 2023
    • 7

    #1

    Timescale backup and upgrade

    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.

  • cyber
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • Dec 2006
    • 4807

    #2
    Not really a Zabbix question..
    But if you upgrade your zabbix you should create your DB with old zabbix version db schema and then let upgrade tasks do the magic of converting everything that is needed for new one.
    What I did, was export data as csv from old version and import it to new one (with newer versions of PG and TS, but with a DB schema of old zabbix version). CSV does not have anything about hypertables etc in it.. it is just data. In such case you get working PG and TS, with new versions, which will manage your inserted data without any of previous hypertable setup... it just creates new one during inserting...
    pg_dump would require same major versions of pg and ts ...

    Comment

    Working...