[PostgreSql + Mac m1 ] connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directoryIs the server running locally and accepting connections on that socket?

PostgreSql을 설치 후 [ psql postgres ] 명령어를 통해 접속을 시도했지만 하단의 Error를 만나게 되었다.

psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?

psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory Is the server running locally and accepting connections on that socket?

 

1. 원인

원인은 PC 내부 프로세스의 충돌 문제로 인한 PostgreSQL 오류였습니다.

 

2. 해결

터미널에 아래의 명령어를 입력하면 해당 Error가 해결됩니다.

brew services stop postgresql
rm /usr/local/var/postgres/postmaster.pid  # 이 부분이 pid 조정하는 부분
brew services start postgresql

---

참고 블로그

[2019.10.29] PostgreSQL - psql: could not connect to server: No such file or directory is the server running locally and accepti