We ran brew update on Mac recently. After the update, the postgres count not start and we got the issue. We tried to uninstall postgres and install it again. It didn’t help. We got the following issue when we type:
$ psql 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"?
A pid file existed as a lock file. The pid file was blocking postgres from starting up. As soon as we remove the pid file the issue was resolved.
$ rm /usr/local/var/postgres/postmaster.pid $ brew services restart postgresql