Zabbix backup

https://catonrug.blogspot.com/2020/05/postgresql-zabbix-database-backup.html

.env

export PGSSLMODE=prefer
export PGHOST=zabbix-postgresql.zabbix.svc.cluster.local
export PGPORT=5432
export PGDATABASE=zabbix
export PGUSER=zabbix
export PGPASSWORD=mypass

#!/bin/bash
ts=`date +%Y-%m-%d_%H-%M-%S`
pg_dump \
--file=zabbix.$ts.pg_dump \
--format=custom \
--blobs \
--verbose \
--exclude-table-data '*.history*' \
--exclude-table-data '*.trends*'
# --exclude-table-data '*.auditlog*' \

Backup:

pg_dump \
--dbname=DATABASE \
--host=HOST \
--username=USER \
--file=zabbix44.dump \
--format=custom \
--blobs \
--verbose \
--exclude-table-data '*.history*' \
--exclude-table-data '*.trends*'

To ignore hypertables:

pg_dump \
--dbname=DATABASE \
--host=HOST \
--username=USER \
--file=zabbix44.dump \
--format=custom \
--blobs \
--verbose \
--exclude-schema=_timescaledb_internal \
--exclude-schema=_timescaledb_cache \
--exclude-schema=_timescaledb_catalog \
--exclude-schema=_timescaledb_config \
--exclude-table-data '*.history*' \
--exclude-table-data '*.trends*'

With maximum compression:

pg_dump \
--dbname=DATABASE \
--host=HOST \
--username=USER \
--file=zabbix40.pg10.dump \
--format=custom \
--compress=9 \
--blobs \
--verbose \
--exclude-table-data '*.history*' \
--exclude-table-data '*.trends*'

Restore:

pg_restore \
--dbname=<database> \
--host=<host> \
zabbix44.dump