Files
ITWorx-Pulse-Public/docs/architecture/adr/0004-postgresql-domain-state.md
ITWorx Pulse release export bd774932d5
Public source validation / validate (push) Failing after 3m8s
Publish ITWorx Pulse source
2026-09-03 02:09:19 +02:00

559 B

ADR 0004 — PostgreSQL stores Pulse domain state

Status: Accepted baseline

Decision

Use PostgreSQL for configuration, inventory, relationships, dashboards, events, alert state/history, incidents, audit and job coordination.

Rationale

The data is relational, transactional and queryable. PostgreSQL supports JSONB for bounded extensibility and reliable migrations/backups.

Consequences

  • All schema changes use migrations.
  • Production database is private.
  • Backup/restore is a release gate.
  • Metric samples remain outside PostgreSQL.