The main tricky bit is making sure you're snapshotting/backing up everything frequently.

Yeah this can be crappy.

SaaS products

There's managed postgres on aws, ovh, heroku, digital ocean, vultr, fly.io