Hey there,
I see you’re going through some postgres issues. Thanks for taking some troubleshooting steps on your own and letting us know what’s not working. Have you tried to restart your machine by any chance?
Here’s the doc on how to do so- fly machine restart · Fly Docs
I found a post that is similar to what you are going through and looks like someone else also fixed their issue by restarting their machine. Here’s that post for reference- PostgreSQL DB resource limits reached