This guide helps you migrate full Home Assistant history from the default home-assistant_v2.db
(SQLite) to a PostgreSQL 17 instance deployed via TrueNAS SCALE Apps.
It supports:
- ✅
statistics_meta
,statistics
,statistics_short_term
- ✅
recorder_runs
,schema_changes
- ✅
event_types
,states_meta
,event_data
,state_attributes
,events
,states