Skip to main content
Important: We are not able to provide support or guidance for unmanaged Postgres. We now offer Fly.io Managed Postgres , our fully-managed database service that handles all aspects of running production PostgreSQL databases.
A Postgres cluster is configured with three users when created:
  • postgres - a role with superuser and login privileges that was created for you along with the cluster. Since the postgres role has superuser rights, it’s recommended that you only use it for admin tasks and create new users with access restricted to the minimum necessary for applications
  • flypgadmin - a role used internally by Fly.io to configure and query the Postgres cluster
  • repmgr - a role used by repmgr to manage replication for the Postgres cluster
If you attached a Fly App to your Postgres cluster app with fly postgres attach, then you’ll have a an additional database and user with the same name as the consuming app. You can list users with flyctl. For example, for a Postgres cluster app named pg-test:
In this example, there’s an attached Fly App in the list of users.