It’s a little inelegant, but probably it’s easiest to just create a completely new Postgres app (fly pg create).
This older thread might help:
https://community.fly.io/t/urgency-problems-with-postgres-the-database-is-not-responding/19926/2
(You would leave off the --fork-from and --initial-cluster-size in this case, of course.)