CODEWITHSUNDEEP
postgresql
s_spirit
s_spirit

Reputation: 115

Postgres cant connect to server: No such file or directory

I'm running Debian server and use SSH to manage it. Today I tried to install Postgres and follow this steps to do it:

apt-get install postgresql

su - postgres

psql

After the last command I got:

psql: could not connect to server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

I found several solutions in the Web, but all of them doesn't works for me. As example I found, that I need to delete "postmaster.pid" in here:

/usr/local/var/postgres/postmaster.pid

But I have no such directory as "postgres" in my "var" folder...

Please, help...:(

Upvotes: 0

Views: 652

Answers (1)

Daniel Vérité
Daniel Vérité

Reputation: 61516

What you did is correct and normally sufficient except when something goes wrong with the automatic creation of the first cluster by apt-get install postgresql. Often there is an error message like this in the middle of the success reports:

Error: could not create default cluster

Since you can't have done any work with postgres yet, purge the packages with

apt-get purge 'postgresql*'

then reinstall with

apt-get install postgresql

but this time, pay close attention to any error message that would imply that the initial cluster was not created, that will give the actual reason of the problem.

Upvotes: 1

Related Questions