Ok, thanks. Yeah, I don’t use PostgreSQL much, so I have to get my head into it.
That said, it’s only for Immich, so I could just wipe it and start again which might be quicker… it only took 3 days to scan the photos, it might take me longer to update the database 😉
Feel free to ask over at !homeassistant@lemmy.world too.
But to echo some other comments here, whatever you do, keep it simple and ensure a botched HA update doesn’t freeze / cook you by using standard components as a backup / failsafe