Sstrhsrtj

I am running Ubuntu 16.04 operating system and have recently installed postgres using the instructions given in https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-ubuntu-16-04.

However, when I tried to use postgres using

snowbell@snowbell-Aspire-4738Z:/var/www$ sudo -i -u postgres

postgres@snowbell-Aspire-4738Z:~$ psql

I got the following error message

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

postgres@snowbell-Aspire-4738Z:~$ sudo -u postgres psql

postgres is not in the sudoers file.  This incident will be reported.

In order to get away with this error, I tried using

snowbell@snowbell-Aspire-4738Z:~$ sudo -u postgres psql -p 5432 -h 127.0.0.1

As a result, I got the following error

psql: could not connect to server: Connection refused

Is the server running on host "127.0.0.1" and accepting

TCP/IP connections on port 5432?

Any clues?

The output is as follows

Here is the Sample_error file blissini

If you have exhausted what has been suggested in the comments then the error itself may be related to a misconfiguration of postgresql, which causes the server to crash before it starts.

I would suggest following these instructions:

1. Ensure that postgresql service is running, using sudo service postgresql start




2. Run pg_lsclusters from your terminal



3. Check what is the cluster you are running, the output should be something like:

Version - Cluster Port Status Owner Data directory

9.6 ------- main -- 5432 online postgres /var/lib/postgresql/9.6/main

4. Copy the info from the version and the cluster, and use like so: pg_ctlcluster <version> <cluster> start, for example: pg_ctlcluster 9.6 main start




5. If something is wrong, then postgresql will generate a log, that can be accessed on /var/log/postgresql/postgresql-<version>-main.log, for example:

2017-07-13 16:53:04 BRT [32176-1] LOG: invalid authentication method "all" 

2017-07-13 16:53:04 BRT [32176-2] CONTEXT: line 90 of configuration file "/etc/postgresql/9.5/main/pg_hba.conf" 

2017-07-13 16:53:04 BRT [32176-3] FATAL: could not load pg_hba.conf

Whatever error the log gives you, fix it and restart postgresql service through:

sudo service postgresql restart