The volume-forking trick (with explicit volume ID) from earlier is inelegant but is usually enough to shake people free of this:
https://community.fly.io/t/urgency-problems-with-postgres-the-database-is-not-responding/19926/2
You may need an explicit --image-ref, if your PG Flex version is on the older side.