Repack base de donnée

Entraide Home Assistant
3

voila mon automatisation

automation:  # https://www.home-assistant.io/integrations/automation/
- id: 'purge_automatique_si_base_trop_volumineuse'
  alias: 'Purge de la base de donnée'
  description: 'Purge la base de donnée lorque celle-ci dépasse 5Go'
  trigger:
  - platform: numeric_state
    entity_id: sensor.db_size
    above: "5000.00"
  condition: []
  action:
  - service: recorder.purge
    data:
      keep_days: 31
      repack: true
  mode: single

couplé à un sensor de la taille de ma db

sensor: # https://www.home-assistant.io/integrations/sensor/
  - platform: sql
    queries:
      - name: DB Size
        query: 'SELECT ROUND(page_count * page_size / 1024 / 1024, 1) as size FROM pragma_page_count(), pragma_page_size();'
        column: 'size'
        unit_of_measurement: 'MiB'
1 « J'aime »