In the past decade, Ubicloud has worked with numerous PostgreSQL users, providing insights into differences between running PostgreSQL for yourself versus managing it for others. The blog post discusses key features common in a managed service, such as provisioning, backup/restore, HA, and security, highlighting the complexities involved in each area. Surprisingly, the on-demand provisioning process involves handling various extensions, server certificates, DNS records, and more, requiring multiple optimization steps to reduce the provisioning time. Furthermore, the importance of high availability and security measures, including preventing unauthorized OS access via PostgreSQL commands, are emphasized. Ubicloud stands out for its detailed explanation of managing PostgreSQL for others and invites questions to foster further discussions.
https://www.ubicloud.com/blog/difference-between-running-postgres-for-yourself-and-for-others