Hello all,
My Homeassistant database is currently written on a separate MaraiaDB database server. However, the performance is not quite optimal and the version is already outdated. I would therefore like to switch to Postgres 14. Does anyone have any ideas on how best to make the switch?
I know I’m a bit late, but I’m trying to do just that with pgloader. I’ll keep you posted if it works…
It worked really well. I had an issue with pgloader and a new version of MySQL, but when I managed to downgrade MySQL, I was able to pgload everything into postgres, rebooted homeassistant and voilà