** Description changed: Upstream will push out new microreleases tomrorw 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: + SRU TEST CASE: * 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 + + With 9.1.17 (or earlier versions than 9.1.16) this should succeed.
** Tags added: regression-release -- You received this bug notification because you are a member of Desktop Packages, which is subscribed to postgresql-9.1 in Ubuntu. https://bugs.launchpad.net/bugs/1461425 Title: New upstream microreleases 9.1.17, 9.3.8, 9.4.3 - fixes regression in previous update Status in postgresql-9.1 package in Ubuntu: Invalid Status in postgresql-9.3 package in Ubuntu: Invalid Status in postgresql-9.4 package in Ubuntu: In Progress Status in postgresql-9.1 source package in Precise: In Progress Status in postgresql-9.1 source package in Trusty: New Status in postgresql-9.3 source package in Trusty: New Status in postgresql-9.4 source package in Utopic: New Status in postgresql-9.4 source package in Vivid: New Status in postgresql-9.4 source package in Wily: In Progress Status in postgresql-9.1 package in Debian: Unknown Bug description: Upstream will push out new microreleases tomorrow 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. SRU TEST CASE: * 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 With 9.1.17 (or earlier versions than 9.1.16) this should succeed. To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/postgresql-9.1/+bug/1461425/+subscriptions -- Mailing list: https://launchpad.net/~desktop-packages Post to : [email protected] Unsubscribe : https://launchpad.net/~desktop-packages More help : https://help.launchpad.net/ListHelp
