Postgres connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Question

I am running MacOS 10.14.1 (absolutely new to MacOS), I am unable to run psql command installed through brew, I get the following error, would love some help:

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"?

Solutions I have tried

brew services start service already running
brew services stop postgresql, brew services start postgresql still same error
brew remove postgres, brew install postgres, psql still same error
brew unlink postgresql && brew link postgresql still same error
rm -f /usr/local/var/postgres/postmaster.pid my /usr/local/var/ does not contain a postgres/ folder

One more thing to note, when I brew install postgres I get a warning:

Warning: The post-install step did not complete successfully
You can try again using `brew postinstall postgresql`

running brew postinstall postgresql gives the same warning.

Hopefully provided enough information to go by, happy to provide more.

Have you tried brew update ? That fixes a lot of issues when brew has some out of date modules. brew doctor will also solve some issues. If no luck, brew config and paste the results so we can see what version you are running and status. — Dan
– Dan, Commented Nov 25, 2018 at 9:42
Sure have tried brew update and brew doctor (would love to know what these do - feel free to drop a reference site) ... the output of my brew config is below (I notice the last line being Xcode: N/A I remember reading something about this... — Devatanu
– Devatanu, Commented Nov 25, 2018 at 9:56
HOMEBREW_VERSION: 1.8.3 ORIGIN: github.com/Homebrew/brew HEAD: 4021aa80dfbaa369ee357a955c0216f9566133ac Last commit: 8 days ago Core tap ORIGIN: github.com/Homebrew/homebrew-core Core tap HEAD: 39e578fe3c0fbde142ea94ba2a9c6184f5aef97e Core tap last commit: 12 hours ago HOMEBREW_PREFIX: /usr/local CPU: quad-core 64-bit kabylake Homebrew Ruby: 2.3.7 => /System/Library/Frameworks/Ruby.framework/Versions/2.3/usr/bin/ruby Clang: 10.0 build 1000 Git: 2.19.1 => /usr/local/bin/git Curl: 7.54.0 => /usr/bin/curl macOS: 10.14.1-x86_64 CLT: 10.1.0.0.1.1539992718 Xcode: N/A — Devatanu
– Devatanu, Commented Nov 25, 2018 at 9:57

user3402754 · Accepted Answer · 2019-09-01 17:43:43Z

2

The reason for this is that the process is running but the postmaster.pid file is missing from /usr/local/var/postgres/, so you need to start the process for Postgres which creates postmaster.pid.

If the process is already running,

Stop it manually using the command below:

pg_ctl -D /usr/local/var/postgres stop -s -m fast

Start it manually using the command below:

pg_ctl -D /usr/local/var/postgres -l /usr/local/var/postgres/server.log start

now all should be working just fine.

answered Sep 1, 2019 at 17:43

user3402754

3,1052 gold badges21 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Charlie 木匠 Over a year ago

Super. It's working for me on Mac. I need run this before: brew services stop postgresql

Armali · Accepted Answer · 2019-02-06 07:13:53Z

0

Try this

initdb /usr/local/var/postgres

edited Feb 6, 2019 at 7:13

Armali

19.6k15 gold badges64 silver badges185 bronze badges

answered Feb 6, 2019 at 6:33

Prike

7311 bronze badges

Comments

Daniel Harvey · Accepted Answer · 2020-05-26 21:21:11Z

-3

I just hit this with an existing brew install of 12.1.

brew uninstall postgresql
brew install postgresql

This fixed it. Also took me from 12.1 to 12.3.

edited May 26, 2020 at 21:21

answered May 26, 2020 at 20:37

Daniel Harvey

3795 silver badges16 bronze badges

Collectives™ on Stack Overflow

Postgres connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related