Question

postgress - Could not start /run any command

Posted September 28, 2014 1.8k views

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.

Add a comment
keuchakian
By:
keuchakian
Add a comment

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
1 answer
asb 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 Report
Submit an Answer

Looking for something else?

Ask a new question Search for more help