Public bug reported: 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: * 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 ** Affects: postgresql-9.1 (Ubuntu) Importance: Undecided Status: Invalid ** Affects: postgresql-9.3 (Ubuntu) Importance: Undecided Status: Invalid ** Affects: postgresql-9.4 (Ubuntu) Importance: Undecided Assignee: Martin Pitt (pitti) Status: In Progress ** Affects: postgresql-9.1 (Ubuntu Precise) Importance: High Assignee: Martin Pitt (pitti) Status: In Progress ** Affects: postgresql-9.1 (Ubuntu Trusty) Importance: Undecided Status: New ** Affects: postgresql-9.3 (Ubuntu Trusty) Importance: Undecided Status: New ** Affects: postgresql-9.4 (Ubuntu Utopic) Importance: Undecided Status: New ** Affects: postgresql-9.4 (Ubuntu Vivid) Importance: Undecided Status: New ** Affects: postgresql-9.4 (Ubuntu Wily) Importance: Undecided Assignee: Martin Pitt (pitti) Status: In Progress ** Affects: postgresql-9.1 (Debian) Importance: Unknown Status: Unknown ** Description changed: - Upstream will push out new microreleases after a pretty severe + 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: - * install postgresql-9.1 - * pkill -SEGV postgres - * service postgresql start + * 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 ** Also affects: postgresql-9.3 (Ubuntu) Importance: Undecided Status: New ** Also affects: postgresql-9.4 (Ubuntu) Importance: Undecided Status: New ** Also affects: postgresql-9.1 (Ubuntu Trusty) Importance: Undecided Status: New ** Also affects: postgresql-9.3 (Ubuntu Trusty) Importance: Undecided Status: New ** Also affects: postgresql-9.4 (Ubuntu Trusty) Importance: Undecided Status: New ** Also affects: postgresql-9.1 (Ubuntu Vivid) Importance: Undecided Status: New ** Also affects: postgresql-9.3 (Ubuntu Vivid) Importance: Undecided Status: New ** Also affects: postgresql-9.4 (Ubuntu Vivid) Importance: Undecided Status: New ** Also affects: postgresql-9.1 (Ubuntu Wily) Importance: Undecided Status: New ** Also affects: postgresql-9.3 (Ubuntu Wily) Importance: Undecided Status: New ** Also affects: postgresql-9.4 (Ubuntu Wily) Importance: Undecided Status: New ** Also affects: postgresql-9.1 (Ubuntu Precise) Importance: Undecided Status: New ** Also affects: postgresql-9.3 (Ubuntu Precise) Importance: Undecided Status: New ** Also affects: postgresql-9.4 (Ubuntu Precise) Importance: Undecided Status: New ** Also affects: postgresql-9.1 (Ubuntu Utopic) Importance: Undecided Status: New ** Also affects: postgresql-9.3 (Ubuntu Utopic) Importance: Undecided Status: New ** Also affects: postgresql-9.4 (Ubuntu Utopic) Importance: Undecided Status: New ** No longer affects: postgresql-9.1 (Ubuntu Utopic) ** Bug watch added: Debian Bug tracker #786874 http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=786874 ** Also affects: postgresql-9.1 (Debian) via http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=786874 Importance: Unknown Status: Unknown ** Summary changed: - New upstream microreleases 9.1.17, 9.3.8, 9.4.3 + New upstream microreleases 9.1.17, 9.3.8, 9.4.3 - fixes regression in previous update ** No longer affects: postgresql-9.1 (Ubuntu Wily) ** No longer affects: postgresql-9.4 (Ubuntu Precise) ** No longer affects: postgresql-9.4 (Ubuntu Trusty) ** No longer affects: postgresql-9.3 (Ubuntu Wily) ** No longer affects: postgresql-9.3 (Ubuntu Vivid) ** No longer affects: postgresql-9.3 (Ubuntu Utopic) ** No longer affects: postgresql-9.3 (Ubuntu Precise) ** Changed in: postgresql-9.3 (Ubuntu) Status: New => Invalid ** Changed in: postgresql-9.4 (Ubuntu Wily) Status: New => In Progress ** Changed in: postgresql-9.4 (Ubuntu Wily) Assignee: (unassigned) => Martin Pitt (pitti) ** Changed in: postgresql-9.1 (Ubuntu Precise) Importance: Undecided => High ** Changed in: postgresql-9.1 (Ubuntu Precise) Status: New => In Progress ** Changed in: postgresql-9.1 (Ubuntu Precise) Assignee: (unassigned) => Martin Pitt (pitti) ** No longer affects: postgresql-9.1 (Ubuntu Vivid) ** Changed in: postgresql-9.1 (Ubuntu) Status: New => Invalid -- 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 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: * 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 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

