Ubuntu
postgresql-9.1 package

  1. Bug #1461425
  2. Comment #0

Comment 0 for bug 1461425

Revision history for this message
Martin Pitt (pitti) wrote : New upstream microreleases 9.1.17, 9.3.8, 9.4.3

Upstream will push out new microreleases after a pretty severe regression in the previous rounds of updates:

https://wiki.postgresql.org/wiki/May_2015_Fsync_Permissions_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:
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