While I love postgres, I take issue with coupling too much application logic to the DB. It’s much easier to update/rollback stateless containers/cloud functions/VMs than to recover a DB.

Why is it easier?

You don’t need to operate on the entire database. You can backup or roll back individual tables and schemas.