danieleparazza

## home-assistant-sqlite-postgres-migration-script.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                danieleparazza
                / home-assistant-sqlite-postgres-migration-script.md
            
            
              Last active
              July 22, 2025 12:11
            
              
                Home Assistant statistic database migration from SQLite to PostgreSQL
              
          
    🛠️ Home Assistant History Migration: SQLite → PostgreSQL 17 on TrueNAS (Docker)

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


## hvac_pause.yaml
#ver. 2.0.0
blueprint:
  name: HVAC Pause V2.0.0
  description: Pauses HVAC when windows/doors open; resumes full previous state once closed (with wait-for-confirmed state)
  domain: automation
  input:
    climate_device:
      name: Climate Device
      description: Climate entity used for climate control.
      selector:
	#ver. 2.0.0
	blueprint:
	name: HVAC Pause V2.0.0
	description: Pauses HVAC when windows/doors open; resumes full previous state once closed (with wait-for-confirmed state)
	domain: automation
	input:
	climate_device:
	name: Climate Device
	description: Climate entity used for climate control.
	selector: