Go ahead, self-host Postgres
Note
it's still not the easiest decision to make. the tradeoffs still exist, though they are shifting as the prices increase and postgres continues its rampage to be the undisputable best tool for ... checks notes ... everything.
Summary
Self-hosting Postgres is simpler and cheaper than managed services suggest, with comparable reliability and better performance tunability.