Unable to start PostgreSQL

Question

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 uninstalled and installed postgresql but nothing works for me.

$ sudo service postgresql start
 * Starting PostgreSQL 10 database server                                                                                                       
 * Failed to issue method call: Unit [email protected] failed to load: No such file or directory. See system logs and 'systemctl status [email protected]' for details.

systemctl status postgresql 
Failed to issue method call: No such interface 'org.freedesktop.DBus.Properties' on object at path /org/freedesktop/systemd1/unit/postgresql_2eservice

$ psql -V
psql (PostgreSQL) 10.4 (Ubuntu 10.4-2.pgdg14.04+1)

Make sure you add your server to your PostgreSQL\9.4\data\pg_hba.conf file — Juan Carlos Oropeza
– Juan Carlos Oropeza, Commented Jul 23, 2018 at 13:33
What was the issue, did u solve it. I have exacly the same problem — sonic
– sonic, Commented Oct 16, 2018 at 12:48
Is it a new installation or an upgrade? Is this on linux? I also advise to move the question to dba.stackexchange.com since the question is not related to programming. — kometen
– kometen, Commented Oct 28, 2018 at 9:30

HudsonPH · Accepted Answer · 2018-10-31 15:18:32Z

2

This problem /var/run/postgresql/.s.PGSQL.5432 is about permission,

did you change the database directory? if yes so you need to give write and read permission to the postgres

sudo chown -R postgres:postgres <directory_path>

or

sudo chmod -R 777 <directory_path>

case you cannot use remote access, on pg_config edit this line listen_addresses = 'localhost' to listen_addresses = '*'

and in the pg_hba.conf insert this line:

host    all  all  0.0.0.0/0  md5

edited Oct 31, 2018 at 15:18

answered Oct 31, 2018 at 15:09

HudsonPH

1,8783 gold badges24 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unable to start PostgreSQL

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related