How We Built Fly Postgres

Fly.io has a database offering called Fly Postgres, which allows users to spin up a Postgres database or a whole cluster with just a few commands. The platform started without durable storage and focused on edge apps but later evolved to support whole big applications running on Fly.io. Fly Postgres is an automated database rather than a managed one, using open-source tools like Stolon for clustering and HAProxy for routing connections. Users can deploy the Fly Postgres app with fly launch or use the fly pg create command for a more convenient experience. The platform also supports backups by taking consistent, block-level snapshots of the underlying storage devices.