Ad Widget

Collapse

Backup of trends, history and alarms in PostgreSQL with TimescaleDB

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • karel_b
    Junior Member
    • Feb 2017
    • 7
    #1

    Backup of trends, history and alarms in PostgreSQL with TimescaleDB

    Hi,

    please any ideas, links, what is the recommended way to perform full Zabbix postgresql backup including trend, history and alert data?
    I need to be able to fully restore Zabbix instance including historic data in case of system failure.

    Thanks
    Karel B.
    Tags: backup, postgresql
    • eithor
      Member
      • May 2020
      • 50
      #2
      Look at the timescaledb documentation: https://docs.timescale.com/timescale...ntire-database

        Comment

        • karel_b
          #2.1
          karel_b commented
          11-05-2021, 17:27
          Editing a comment
          Many thanks! It looks feasible.
        • cyber
          Senior Member
          Zabbix Certified SpecialistZabbix Certified Professional
          • Dec 2006
          • 4806
          #3
          nothing from here ?
          Chapter 25. Backup and Restore
          https://www.postgresql.org/docs/11/backup.html
          Chapter 25. Backup and Restore Table of Contents 25.1. SQL Dump 25.1.1. Restoring the Dump 25.1.2. Using pg_dumpall 25.1.3. Handling Large Databases …

          ...

            Comment

            Previous template Next
            Working...