As a temporary work-around, I have overriden the default environment variable that enables scale to zero.
fly secrets set -a my-postgres-app-name FLY_SCALE_TO_ZERO=
The postgres app is now always online - it’s not ideal, but at least it’s not stuck in a suspended state.