postgress - Could not start /run any command

September 28, 2014 1.5k views
keuchakian
By:
keuchakian

Hi folks, i've experienced some issues with the installation of postgres.
I already have it, but i couldnt run any command, including the "createdb".
The error message that i've received is:
createdb: could not connect to database template1: 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 have checked the conf file and it accepts connections from localhost.
Could you please help on this? I have to put my site online asap.

Log In to Comment
1 Answer
asb MOD September 29, 2014

From the look of it, it's trying to connect to a socket file while the database is actually running on the localhost. Can you create a database with the following?

createdb -U dbuser -h localhost -d my_database

This command should confirm whether it is available on the localhost:

sudo netstat -plunt | grep postgres
Reply
Have another answer? Share your knowledge.