Recent searches
Search options
I wrote a #howto showing how to switch your #HomeAssistant to use #postgresql instead of the default SQLite. It was before I had this fediverse account, so I'm reposting the link.
https://unixorn.github.io/post/hass-using-postgresql-instead-of-sqlite/
The Plural of SRE is an OutageSwitch Home Assistant to Use PostgreSQL Instead of SQLiteI wanted to switch my new Home Assistant (HA) installation to write its history data to PostgreSQL instead of SQLite for a variety of reasons. Here’s how I did it.
Here’s why I decided to switch:
Resilience. If you’re running Home Assistant on a Raspberry Pi’s SD card, the constant churn of history updates will eventually destroy the card. The more entities you have, the faster HA will grind your SD card to failure. Writing all that to another server that is writing to a real SSD or spinning disk eliminates that problem.
Convenience. I can back up the postgres database without having to stop HA. I don’t even have to run the backup on the HA server.
Speed. Using a real database will speed up history display, especially once you have a large number of entities.
@unixorn nice! My HA became unresponsive about once a week and when I finally checked it turned out the SQLite db kept getting corrupted. I ended up switching to MariaDB
MySQL is a fine alternative.
It and Postgres can both handle millions of rows so they're really kind of overkill for Home Assistant.
I don't mind overkill if it makes things more reliable, though.