Sample Header Ad - 728x90

How do I connect to a PostGres 14 server installed via Homebrew on Mac OS Big Sur?

-1 votes
1 answer
522 views
I installed PostGreSQL 14 via Homebrew. I seem to be able to restart my local server ... $ brew services restart postgresql@14 Stopping postgresql@14... (might take a while) ==> Successfully stopped postgresql@14 (label: homebrew.mxcl.postgresql@14) ==> Successfully started postgresql@14 (label: homebrew.mxcl.postgresql@14) but whenever I try and connect, I repeatedly get this error $ psql -Upostgres 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? What is the proper way to connect via psql to PostGres 14 on Mac OS Big Sur?
Asked by Dave (753 rep)
Nov 13, 2023, 03:09 AM
Last activity: Nov 14, 2023, 12:01 PM