Currently, we are using Zabbix to monitor hundreds of servers.
Full PostgreSQL database backups are performed daily. Since there is more than one administrator, some of them not very experienced with Zabbix, there is risk of some misconfiguration.
As a solution, we decided to create configuration snapshots from cron, multiple times per day so that we can revert to previous working setup in a case of mistakes.
We found some scripts on the internet that claim to do what we need. Backup is done of everything except: acknowledges alerts auditlog auditlog_details escalations events history* trends*. The issue, however, is that such backup can not be restored over non empty database.
Dropping users or media_type, for example, is not possible because of constraints depending on keys in those tables.
Any idea how to do this?
Maybe partial backup idea is whole wrong and we should do some exports/imports trough API. Anyway, any idea is more than welcome.
Full PostgreSQL database backups are performed daily. Since there is more than one administrator, some of them not very experienced with Zabbix, there is risk of some misconfiguration.
As a solution, we decided to create configuration snapshots from cron, multiple times per day so that we can revert to previous working setup in a case of mistakes.
We found some scripts on the internet that claim to do what we need. Backup is done of everything except: acknowledges alerts auditlog auditlog_details escalations events history* trends*. The issue, however, is that such backup can not be restored over non empty database.
Dropping users or media_type, for example, is not possible because of constraints depending on keys in those tables.
Any idea how to do this?
Maybe partial backup idea is whole wrong and we should do some exports/imports trough API. Anyway, any idea is more than welcome.