Answer the question
In order to leave comments, you need to log in
PostgreSQL won't start, what needs to be fixed?
Available:
Ubuntu 16.04.1 LTS
[email protected] ~ # uname -r
4.4.0-47-generic
[email protected] ~ # service postgresql status
● postgresql.service - LSB: PostgreSQL RDBMS server
Loaded: loaded (/etc/init.d/postgresql; bad; vendor preset: enabled)
Active: active (exited) since Thu 2016-12-01 02:21:43 UTC; 3 days ago
Docs: man:systemd-sysv-generator(8)
Warning: Journal has been rotated since unit was started. Log output is incomplete or unavailable.
[email protected] ~ # psql -h localhost -p 5432 -U postgres -W
Password for user postgres:
psql: could not connect to server: Connection refused
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?
[email protected] ~ # netstat -pant | grep postgres
[email protected] ~ #
[email protected] ~ # sudo su - postgres -c psql
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"?
[email protected] ~ # ps aux|grep postgres
root 29349 0.0 0.0 16976 936 pts/0 S+ 12:00 0:00 grep --color=auto postgres
# - Connection Settings -
listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost'; use '*' for all
# (change requires restart)
port = 5432 # (change requires restart)
max_connections = 100 # (change requires restart)
#superuser_reserved_connections = 3 # (change requires restart)
unix_socket_directories = '/var/run/postgresql' # comma-separated list of directories
# (change requires restart)
Answer the question
In order to leave comments, you need to log in
Demolished. Reinstalled everything. It is not known why this happened ... and there are no ends to be found. It is written that the DBMS is 9.5, but in reality it should have been 9.4
Perhaps the space in /var
df -h has run out, what does it show?
Move/remove large files, archives from /var/log, then try to start PostgreSQL again.
So does psql start say something intelligible?
The server does not start, incl. it is clear that all attempts to connect and the output of netstat will be inconclusive.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question