TLDR Web Dev · ARTICLES & TUTORIALS

DIFFERENCE BETWEEN RUNNING POSTGRES FOR YOURSELF AND FOR OTHERS

ubicloud.com8 min read

Summary from the TLDR Web Dev newsletter

Running PostgreSQL for others requires additional steps compared to running it for yourself, such as installing extensions, creating server certificates, configuring settings, and creating DNS records. Faster provisioning happens thanks to optimizations like using a baked OS image, parallelizing steps, and creating a pool of pre-provisioned databases. High Availability involves provisioning primary and standby databases, regular health checks, and ensuring proper fencing of the primary in case of failure.