"It works on my machine" — so we stopped trusting my machine

Callback. The fix for that old curse is not a better machine — it is to stop trusting any machine. The scenario above runs against a real, throwaway Postgres, so the environment is pinned in code, not remembered on a box.