Skip to content

Instantly share code, notes, and snippets.

View danieleparazza's full-sized avatar

danieleparazza

View GitHub Profile
@danieleparazza
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
@danieleparazza
danieleparazza / hvac_pause.yaml
Last active July 7, 2025 14:41 — forked from raffy-ops/hvac_pause.yaml
HA HVAC Pause Blueprint V2
#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: