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
Last activity: Nov 2, 2021, 01:24 PM