I'm using postgres 9.5 on Ubuntu 16.04. I have worked with pg in my notebook for almost a month but today postgres did not connected. I tryed both PGAdmin and psql.
I also tried to login using my own user and postgres but I received the messages:
Server doesn't listen The server doesn't accept connections: the connection library reports could not connect to server: Conexão recusada (connection refused) Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?
~$ psql database WARNING: password file "/home/antonio/.pgpass" has group or world access; permissions should be u=rw (0600) or less psql: could not connect to server: Arquivo ou diretório não encontrado (File or directory not found) Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
$ pg_lsclusters Ver Cluster Port Status Owner Data directory Log file 9.5 main 5432 down postgres /var/lib/postgresql/9.5/main /var/log/postgresql/postgresql-9.5-main.log
It was the first time I received the warning "password file "/home/antonio/.pgpass" has group or world access; permissions should be u=rw (0600) or less" and I fixed it:
-rw------- 1 antonio antonio 137 Set 30 18:50 .pgpass
I had edited postgresql.conf and pg_hba.conf but this morning they were in their original configuration. So I edited again to:
# Database administrative login by Unix domain socket local all postgres md5 # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all md5 # IPv4 local connections: host all all 127.0.0.1/32 md5
I also restarted the server (/etc/init.d/postgresql restart) and the computer.