Sample Header Ad - 728x90

psql command will not work in cli MAC. ERR: connection to server on socket "/tmp/.s.PGSQL.5432" failed

1 vote
0 answers
2357 views
I have installed home-brew v14 psql & psql app v14. It will not allow me to use port 5432 (I spent a week getting this to work and it hasnt), so I have made a server on 4321 which will start. when I type psql in my cli, I get the below 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?
I cannot find the tmp folder to change the port to listen too. Any help will be appreciated. I was able to manually change the port back to 5432 in the postgresapp which worked. now I get this error message when I tap 'psql' in the command line:
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL:  role "edac" does not exist
Asked by edwrdcodeu (391 rep)
Nov 2, 2021, 11:50 AM
Last activity: Nov 2, 2021, 01:24 PM