PG::ConnectionBad: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory

An error occurs during deployment.
The error statement is as follows
PG::ConnectionBad: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory

I typed the following command
$ fly postgres connect -a knowledge-tree-quiz-db

I get the following error
Error: no active leader found".

What could be the cause? Can anyone give me some advice?

1 Like

The results of executing the following commands are as follows

$ fly doctor
Testing authentication token… PASSED
Testing flyctl agent… PASSED
Testing local Docker instance… PASSED
Pinging WireGuard gateway (give us a sec)… PASSED
App specific checks for knowledge-tree-quiz:
Checking that app has ip addresses allocated… PASSED
Checking A record for knowledge-tree-quiz.fly.dev… PASSED
Checking AAAA record for knowledge-tree-quiz.fly.dev… PASSED
Build checks for knowledge-tree-quiz:
Checking docker context size (this may take little bit)… PASSED (2.1 MB)
Checking for .dockerignore… PASSED

$ fly version
fly v0.1.56 darwin/arm64 Commit: 7981f99ff550f66def5bbd9374db3d413310954f-dirty BuildDate: 2023-07-12T20:27:19Z

$ fly apps list
NAME OWNER STATUS PLATFORM LATEST DEPLOY
fly-builder-hidden-darkness-4369 personal suspended machines
knowledge-tree-quiz personal suspended machines
knowledge-tree-quiz-db personal pending machines

$ fly dig txt _apps.internal
;; opcode: QUERY, status: NOERROR, id: 50919
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 0
;; QUESTION SECTION:
;_apps.internal. IN TXT
;; ANSWER SECTION:
_apps.internal. 5 IN TXT “fly-builder-hidden-darkness-4369,knowledge-tree-quiz,knowledge-tree-quiz-db”

1 Like