All my projects run on the same postgres version so Homebrew does the trick.
If I have a project on an older version, I'll upgrade - even if that's just making it run locally.
That being said none of my projects do anything "fancy" at the database level.