- BACKUP YOUR HOME ASSISTANT!
- Grab the SQLite database somewhere
- Install pgloader ** Create postgres database:
create database ha_live;
CREATE USER ha_live WITH ENCRYPTED PASSWORD '<password>';
GRANT ALL PRIVILEGES ON DATABASE ha_live TO ha_live;
GRANT ALL ON DATABASE ha_live TO ha_live;