Databases · PostgreSQL
Full operational coverage for PostgreSQL across monitoring, backup and recovery.
SchemaPulse applies the same operational model to PostgreSQL as to every other engine — one console, one policy language for backup and retention, one incident and recommendation pipeline.
PostgreSQL joins SchemaPulse with the same operational model applied to every engine: metrics and query analytics, topology awareness, policy-driven backup with point-in-time recovery, and provisioning.
Support
Versions and deployment
Supported versions
- PostgreSQL 14
- 15
- 16
- 17
- 18
Storage targets
- local
- NFS
- S3
- GCS
Topologies
How SchemaPulse sees PostgreSQL
- Standalone
- Streaming Replication
- Logical Replication
Primary and standby roles, replication slots and replay lag are tracked per instance, with promotion recorded as a topology event.
Capabilities
What is covered on PostgreSQL
- Monitoring
- Database and system metrics from a signed agent on each host
- Query Analytics
- Slow queries, query timeline, index reports, background export
- Backup
- pg_basebackup · pgBackRest · pg_dump
- Point-in-time recovery
- Base backup plus continuous WAL archiving, replayed to the selected recovery target.
- Storage targets
- local · NFS · S3 · GCS
- Provisioning
- Terraform and Ansible, with the agent installed as part of the build
- Integrations
- Jira · PagerDuty · Email
Intelligence
What SchemaPulse recommends on for PostgreSQL
- Index efficiency and unused indexes
- Slow-query regressions and plan changes
- Replication lag
- Bloat and vacuum behaviour
- Backup policies without a successful verification
- Resource saturation trends