Tags

schema-v3.4.0

Release schema v3.4.0 - Network state tables

Database Schema v3.4.0 Release

This release introduces network state-based IP storage, replacing the time-series
metrics_network_ip table with a more efficient state table architecture.

New Features:
- network_interfaces state table (current IP configuration)
- network_ip_changes audit log (IP change history)
- State-based storage: 99.4% storage reduction vs time-series
- Helper functions: get_probe_network_interfaces(), get_network_ip_history()
- 90-day retention for IP change audit log

Schema Files:
- 07_v3.4_network_state_tables.sql (migration from v3.1.0)
- 08_v3.4_schema.sql (complete fresh install schema)

Fixes:
- Enable compression on hypertables before adding policies
- Remove incompatible COMMENT statements on continuous aggregates
- Fix reserved keyword conflict in get_network_ip_history function

Compatibility:
- Requires Collector v3.4.0+
- Backward compatible with Probe v2.1.0+
- TimescaleDB 2.x+ required
- PostgreSQL 13+ required

Storage Impact:
- Network IPs: 1,860 rows → 15 rows per probe (99.4% reduction)
- IP changes: Only written when changes occur
- Typical savings: ~1GB per 100 probes per year

Migration:
- Existing v3.1.0 deployments: Run 07_v3.4_network_state_tables.sql
- Fresh installs: Run 08_v3.4_schema.sql

Documentation: See Database/sql/README.md for full migration guide