Managing Fly Postgres

This document applies to Postgres clusters running on our next-gen Apps V2 architecture (Fly Machines). If you created your cluster using any flyctl version before v0.0.412, refer to Fly Postgres on Apps V1 and Multi-region PostgreSQL instead.

Users & Roles

Add users and roles to control who can access what in the database.

Attach or Detach a Fly App

fly pg attach: Conveniently create a new database in a Fly Postgres cluster for a Fly app, and give the app credentials to connect.fly pg detach: Conveniently revoke an app's access to a Fly Postgres database.

Monitoring

Configure healthchecks and notifications for when the Postgres database runs into issues, like running out of storage or memory.

Backup, Restores, & Snapshots

Keep your data safe by backing it up and restoring it if the unthinkable happens.

Scale Postgres VMs

Scale Postgres instances up to handle more capacity

Upgrade Postgres

Upgrade Fly instances with the latest version of Postgres.

Configuration Tuning

Learn how to tune your Postgres database to your needs.

Enable TimescaleDB

Learn how to enable Timescale on your Postgres database.

Delete a Postgres Cluster