This particularly affects 9.1 due to the way we handle SSL certificates, i. e. Ubuntu 12.04. Later releases are much less affected as we don't have to symlink the certificate there any more.
The PostgreSQL server failed to start. Please check the log output:
2015-06-03 09:16:35 CEST LOG: database system was interrupted; last known up at 2015-06-03 09:15:27 CEST
2015-06-03 09:16:35 CEST FATAL: could not open file "/etc/ssl/private/ssl-cert-snakeoil.key": Permission denied
2015-06-03 09:16:35 CEST LOG: startup process (PID 10527) exited with exit code 1
2015-06-03 09:16:35 CEST LOG: aborting startup due to startup process failure
Upstream will push out new microreleases after a pretty severe regression in the previous rounds of updates:
https:/ /wiki.postgresq l.org/wiki/ May_2015_ Fsync_Permissio ns_Bug# I.27ve_ hit_this_ bug_and_ I_can.27t_ restart_ Postgres. _What_do_ I_do.3F
This particularly affects 9.1 due to the way we handle SSL certificates, i. e. Ubuntu 12.04. Later releases are much less affected as we don't have to symlink the certificate there any more.
Reproducer:
* install postgresql-9.1
* pkill -SEGV postgres
* service postgresql start
With 9.1.16 this will fail with
The PostgreSQL server failed to start. Please check the log output: private/ ssl-cert- snakeoil. key": Permission denied
2015-06-03 09:16:35 CEST LOG: database system was interrupted; last known up at 2015-06-03 09:15:27 CEST
2015-06-03 09:16:35 CEST FATAL: could not open file "/etc/ssl/
2015-06-03 09:16:35 CEST LOG: startup process (PID 10527) exited with exit code 1
2015-06-03 09:16:35 CEST LOG: aborting startup due to startup process failure