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"?

If we are getting error after creating database in postgres like this :-

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"?

Then use following link :- 

https://stackoverflow.com/questions/42653690/psql-could-not-connect-to-server-no-such-file-or-directory-5432-error

sudo chmod 777 -R /var/run/postgresql/

Then restart the postgres:- 

sudo service postgresql restart 

or 

sudo systemctl start postgresql@9.6-main


 

Comments

Popular posts from this blog

CARRIERWAVE - UPLOAD ANY MEDIA (AUDIO , VIDEO AND IMAGE ) FILE IN RAILS

SELECT COUNTRY WITH STATE AND IT'S CITIES RAILS

SEARCHING USING AJAX IN RAILS

RAILS: UPLOADING PHOTOS VIA AMAZON S3 AND PAPERCLIP (UPLOADING FILES TO S3 IN RUBY WITH PAPERCLIP)

E: Package 'aptitude' has no installation candidate

CURL COMMAND ON RUBY ON RAILS

CHECK PASSENGER RUBY PATH

SHOW LINE NUMBER OF TEXT AREA