Postgresql – Cannot connect to Postgres server running through brew services

homebrewmacospostgresql

I've been looking for a solution for this and could not find a working solution.

I've installed postgres using brew (brew install postgres) in my MacBook and I am currently running it using brew services (brew services list displays postgres as a running service). However, when I try to run psql I get following error.

psql: could not connect to server: No such file or directory Is the
server running locally and accepting connections on Unix domain
socket "/tmp/.s.PGSQL.5432"?

Anyone has already solved similar problem?

Best Answer

I had the same error and I fixed it by removing the process pid file:

rm -f /usr/local/var/postgres/postmaster.pid

Related Solutions

PostgreSQL error ‘Could not connect to server: No such file or directory’

Check there is no postmaster.pid in your postgres directory, probably /usr/local/var/postgres/

remove this and start server.

Check - https://github.com/mperham/lunchy is a great wrapper for launchctl.

Postgresql – psql: could not connect to server [ubuntu]

the above issue seems related to PostgreSQL default port no,

Change the port no in postgresql.conf file and restart the DB server. if u have changed the port while installing.

(OR)

instead of psql type full command like

 "psql -p 5432 -h localhost"

Best Answer

Related Solutions

PostgreSQL error ‘Could not connect to server: No such file or directory’

Postgresql – psql: could not connect to server [ubuntu]

Related Topic