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.
Add users and roles to control who can access what in the database.
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.
Check on the health of your cluster, view logs, see which metrics are available for export.
Keep your data safe by backing it up and restoring it if the unthinkable happens.
Scale Postgres instances up to handle more capacity
Learn about the scale to zero after one hour feature, and how to remove it, for your Postgres Development project.
Learn how to tune your Postgres database to your needs.
Upgrade Fly instances with the latest version of Postgres.
See what platform resources you have provisioned for your Postgres cluster