Postgresql won't start

[DrDinosaur]

root@Kali:~# service postgresql start
[....] Starting PostgreSQL 9.1 database server: main[....] The PostgreSQL server failed to start. Please check the log output: 2015-05-27 01:05:38 HST LOG: could not bind IPv6 socket: Cannot assign requested address 2015-05-27 01:05:38 HST HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry. 2015-05-27 01:05:38 HST LOG: database system was interrupted; last known up at 2015-05-25 13:33:04 HST 2015-05-27 01:05:38 HST LOG: incomplete startup packet 2015-05-27 01:05:38 HST FATAL: could not open file "/etc/ssl/certs/ssl-cert-snakeoil.pem": Permission denied 2015-05-27 01:05:38 HST LOG: s[FAILp process (PID 12419) exited with exit code 1 2015-05-27 01:05:38 HST LOG: aborting startup due to startup process failure ... failed!
failed!

It was working fine earlier. I think an update caused this problem.

[Random User]

I just had the same issue try:


cd /etc/ssl/certs/
chown postgres ssl-cert-snakeoil.pem
chmod 777 ssl-cert-snakeoil.pem

cd /etc/ssl/private
chown postgres ssl-cert-snakeoil.key
chmod 700 ssl-cert-snakeoil.key

This worked for me

[DrDinosaur]

I just had the same issue try:


cd /etc/ssl/certs/
chown postgres ssl-cert-snakeoil.pem
chmod 777 ssl-cert-snakeoil.pem

cd /etc/ssl/private
chown postgres ssl-cert-snakeoil.key
chmod 700 ssl-cert-snakeoil.key

This worked for me

This also worked for me. Thank you.

[D-Li]

I got a message " No such file or directory. what is my issue.