Sample Header Ad - 728x90

PostgreSQL not running on Mac

144 votes
15 answers
373600 views
The error in its entirety reads: > 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"? This is my second time setting up Postgresql via Homebrew on my Mac, and I have no clue what is going on. Previously, it had been working. At some point, I must've entered a command that messed things up. I'm not sure. Now, whenever I enter a SQL command from the command line, I receive the above message. I've run a command to check whether the server is running, and it apparently is not. If I attempt to start the server using > $ postgres -D /usr/local/pgsql/data I receive the following error: > postgres cannot access the server configuration file > "/usr/local/pgsql/data/postgresql.conf": No such file or directory I've uninstalled and reinstalled Postgresql via Homebrew, but the problem persists. I'm completely at a loss as to how to get this working. Any help would be appreciated.
Asked by Michael P. (2111 rep)
Aug 28, 2014, 02:50 PM
Last activity: Apr 12, 2023, 07:12 PM