Been using fly proxy to access couple of “unmanaged postgres” databases when things need manual intervention. But starting from yesterday it seems I’m unable to connect to neither of my db-s with fly proxy.
sql client results in :
connection to server at “127.0.0.1”, port 5432 failed: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Proxy debug shows this when sql client tries to connect:
LOG_LEVEL=debug fly proxy 5432 -a my-app-name-db
Proxying localhost:5432 to remote [my-app-name-db.internal]:5432
// sql client connects
DEBUG accepted new connection from: 127.0.0.1:53277
DEBUG failed to connect to target: dial: lookup my-app-name-db.internal. on fdaa:11:b8f7::3: read udp [fdaa:11:b8f7:a7b:ce2:0:a:0]:25365: i/o timeout
Running out of ideas what to try to debug the issue. The fly machines using the database are working just fine and also fly postgres connect -a my-app-name-db looks to be working.