Ad Widget

Collapse

Zabbix 6.4.13 with TimescaleDB backup, help me please

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • intense
    Junior Member
    • Nov 2023
    • 18

    #1

    Zabbix 6.4.13 with TimescaleDB backup, help me please

    I have Zabbix 6.4.13 with TimescaleDB on PostgreSQL 16.
    Will backup via pg_dump be ok?

    pg_dump --no-owner -h localhost -p 5432 -U zabbix zabbix > /backup/file.sql

    When using TimescaleDB, do I have to do it differently?
    Maybe someone has a proven script?
  • cyber
    Senior Member
    Zabbix Certified SpecialistZabbix Certified Professional
    • Dec 2006
    • 4807

    #2
    pg_dump and pg_restore should do the trick for you...

    Comment

    • intense
      Junior Member
      • Nov 2023
      • 18

      #3
      Ok thanks for answer

      Comment

      • dieselfluxcapacitor
        Junior Member
        • Jul 2023
        • 11

        #4
        intense did using
        Code:
        pg_dump
        work for you? What did your command invocation look like to backup and restore the database?
        I am attempting to migrate to a new PostgreSQL 16 server from PostgreSQL 15 and can't get the data to import properly without a storm of errors. I am also using TimescaleDB
        Last edited by dieselfluxcapacitor; 04-12-2024, 18:14.

        Comment

        Working...