PostgreSQL, fix the `psql: error: could not connect to server` error

This content originally appeared on flaviocopes.com and was authored by flaviocopes.com

I had this problem: I had installed PostgreSQL in the past using Homebrew, then I think I updated its version mindlessly with brew upgrade, and I couldn’t start it again.

It used to work, but now whenever I tried to access it, I got this error:

psql: error: 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"?

The server was running fine, as ps aux | grep postgres showed its process.

I tried various solutions, until simply reinstalling it worked fine.

I ran

brew uninstall postgresql
brew install postgresql
brew services start postgresql

and I was able to connect to the database again.

This content originally appeared on flaviocopes.com and was authored by flaviocopes.com

Print Share Comment Cite Upload Translate Updates

APA

flaviocopes.com | Sciencx (2021-08-23T05:00:00+00:00) PostgreSQL, fix the `psql: error: could not connect to server` error. Retrieved from https://www.scien.cx/2021/08/23/postgresql-fix-the-psql-error-could-not-connect-to-server-error/

MLA

" » PostgreSQL, fix the `psql: error: could not connect to server` error." flaviocopes.com | Sciencx - Monday August 23, 2021, https://www.scien.cx/2021/08/23/postgresql-fix-the-psql-error-could-not-connect-to-server-error/

HARVARD

flaviocopes.com | Sciencx Monday August 23, 2021 » PostgreSQL, fix the `psql: error: could not connect to server` error., viewed ,<https://www.scien.cx/2021/08/23/postgresql-fix-the-psql-error-could-not-connect-to-server-error/>

VANCOUVER

flaviocopes.com | Sciencx - » PostgreSQL, fix the `psql: error: could not connect to server` error. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2021/08/23/postgresql-fix-the-psql-error-could-not-connect-to-server-error/

CHICAGO

" » PostgreSQL, fix the `psql: error: could not connect to server` error." flaviocopes.com | Sciencx - Accessed . https://www.scien.cx/2021/08/23/postgresql-fix-the-psql-error-could-not-connect-to-server-error/

IEEE

" » PostgreSQL, fix the `psql: error: could not connect to server` error." flaviocopes.com | Sciencx [Online]. Available: https://www.scien.cx/2021/08/23/postgresql-fix-the-psql-error-could-not-connect-to-server-error/. [Accessed: ]

rf:citation

» PostgreSQL, fix the `psql: error: could not connect to server` error | flaviocopes.com | Sciencx | https://www.scien.cx/2021/08/23/postgresql-fix-the-psql-error-could-not-connect-to-server-error/ |

Please log in to upload a file.

There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.