Zabbix backup - Revision history

Busk at 15:40, 9 July 2025

2025-07-09T15:40:14Z

Busk at 15:59, 29 May 2022

2022-05-29T15:59:38Z

Busk: Created page with "https://catonrug.blogspot.com/2020/05/postgresql-zabbix-database-backup.html ``` Backup: pg_dump \ --dbname=DATABASE \ --host=HOST \ --username=USER \ --file=zabbix44.dump \..."

2022-05-29T15:58:49Z

Created page with "https://catonrug.blogspot.com/2020/05/postgresql-zabbix-database-backup.html ``` Backup: pg_dump \ --dbname=DATABASE \ --host=HOST \ --username=USER \ --file=zabbix44.dump \..."

New page

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

```
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
```

← Older revision		Revision as of 15:40, 9 July 2025
Line 1:		Line 1:
	https://catonrug.blogspot.com/2020/05/postgresql-zabbix-database-backup.html		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:		Backup:

@@ Line 1: / Line 1: @@
 https://catonrug.blogspot.com/2020/05/postgresql-zabbix-database-backup.html
 ```
 pg_dump \
 --dbname=DATABASE \
@@ Line 13: / Line 14: @@
 --exclude-table-data '*.history*' \
 --exclude-table-data '*.trends*'
 To ignore hypertables:
 pg_dump \
 --dbname=DATABASE \
@@ Line 28: / Line 32: @@
 --exclude-table-data '*.history*' \
 --exclude-table-data '*.trends*'
 With maximum compression:
 pg_dump \
 --dbname=DATABASE \
@@ Line 40: / Line 47: @@
 --exclude-table-data '*.history*' \
 --exclude-table-data '*.trends*'
 Restore:
 pg_restore \
 --dbname=<database> \