What about running your own db instance in a cloud VM? Do you really want to do all the infra management? I've done it and it isn't fun--well it can be making soup-to-nuts IaC recipies, but I wouldn't say it was a good use of my dev/ops working hours.
I think it's not that hard - I have configs and I even build Postgres from source so I can get the same version in dev environments supporting Linux and MacOS.
In production I find it a bit easier to profile what's happening if the db is performing poorly since I can login to the box and use standard tools - is it cpu/io bound, etc.