Difference between revisions of "Zabbix backup"
Jump to navigation
Jump to search
(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 \...") |
|||
| 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 | ||
| + | |||
| + | Backup: | ||
``` | ``` | ||
| − | |||
pg_dump \ | pg_dump \ | ||
--dbname=DATABASE \ | --dbname=DATABASE \ | ||
| Line 13: | Line 14: | ||
--exclude-table-data '*.history*' \ | --exclude-table-data '*.history*' \ | ||
--exclude-table-data '*.trends*' | --exclude-table-data '*.trends*' | ||
| + | ``` | ||
| + | |||
To ignore hypertables: | To ignore hypertables: | ||
| + | ``` | ||
pg_dump \ | pg_dump \ | ||
--dbname=DATABASE \ | --dbname=DATABASE \ | ||
| Line 28: | Line 32: | ||
--exclude-table-data '*.history*' \ | --exclude-table-data '*.history*' \ | ||
--exclude-table-data '*.trends*' | --exclude-table-data '*.trends*' | ||
| + | ``` | ||
| + | |||
With maximum compression: | With maximum compression: | ||
| + | ``` | ||
pg_dump \ | pg_dump \ | ||
--dbname=DATABASE \ | --dbname=DATABASE \ | ||
| Line 40: | Line 47: | ||
--exclude-table-data '*.history*' \ | --exclude-table-data '*.history*' \ | ||
--exclude-table-data '*.trends*' | --exclude-table-data '*.trends*' | ||
| + | ``` | ||
| + | |||
Restore: | Restore: | ||
| + | ``` | ||
pg_restore \ | pg_restore \ | ||
--dbname=<database> \ | --dbname=<database> \ | ||
Latest revision as of 15:59, 29 May 2022
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