It doesn’t look like you have created or attached a postgres database.
To create a database: Create a Fly Postgres Cluster · Fly Docs
To attach a database to your app: Attach or Detach a Fly App · Fly Docs
cool, let me try and see how it goes
the database is already there am getting this error “To create more than 2 apps please add a payment method. Sign In · Fly”
If you run flyctl secrets list and do not see DATABASE_URL listed there is no database attached to this application. To attach an existing database to your current application run flyctl postgres attach specifying the database name. To get a list of databases run flyctl postgres list.