I debated running my own Postgres cluster for a side project, but ended up paying for Digitalocean’s managed offering.

I’d like to hear from anyone running their own Postgres. Why did you choose to do that vs pay for a managed instance? How much of a hassle has it been? Is it something you really need significant Postgres experience to do well (to achieve security, backups, high availability, etc)? Biggest gotchas to watch out for? Best material to read?

Thanks in advance.