How do you update postgres on CoreOS? Its better to keep IT immutable so in case of change the whole image must be recreated?
An immutable OS like CoreOS for example isn't much different than a regular distro. You can still do a lot of manual work on it if you want. I try to avoid doing manual work on it because I want to be strict IaC, but I can for example test doing a major release upgrade in staging, manually over SSH, and work out the kinks, before I put it into practice using containers and scripts in production.
Though I see very little reason to automate the hell out of a major release upgrade, better do it safely and slowly with SOP's.