New upstream microreleases 9.3.20, 9.5.10 and 9.6.6

Bug #1730661 reported by Christian Ehrhardt 
256
This bug affects 1 person
Affects Status Importance Assigned to Milestone
postgresql-10 (Ubuntu)
Fix Released
Undecided
Unassigned
postgresql-9.3 (Ubuntu)
Invalid
Undecided
Unassigned
Trusty
Fix Released
Undecided
Unassigned
postgresql-9.5 (Ubuntu)
Invalid
Undecided
Unassigned
Xenial
Fix Released
Undecided
Unassigned
postgresql-9.6 (Ubuntu)
Invalid
Undecided
Unassigned
Zesty
Fix Released
Undecided
Unassigned
Artful
Fix Released
Undecided
Unassigned

Bug Description

Update to the new set of releases as per the standing micro-release exception these should land in stable Ubuntu releases.

Current versions in releases:
 postgresql-9.3 | 9.3.19-0ubuntu0.14.04 trusty
 postgresql-9.5 | 9.5.9-0ubuntu0.16.04 xenial
 postgresql-9.6 | 9.6.5-0ubuntu0.17.04 zesty
 postgresql-9.6 | 9.6.5-1 artful

No "special" cases known this time.

Last stable updates
PostgreSQL 9.6.6, 9.5.10, 9.4.15, 9.3.20, 9.2.24

So the todo is to pick:
MRE: Trusty 9.3.20 from https://borka.postgresql.org/staging/5d4e3dcc636f182a69ff7ff51286c1a20e930c9e/postgresql-9.3.20.tar.gz
MRE: Xenial 9.5.10 from https://borka.postgresql.org/staging/5d4e3dcc636f182a69ff7ff51286c1a20e930c9e/postgresql-9.5.10.tar.gz
MRE: Zesty 9.6.6 from https://borka.postgresql.org/staging/5d4e3dcc636f182a69ff7ff51286c1a20e930c9e/postgresql-9.6.6.tar.gz
Sync: Artful 9.6.6 as above

Standing MRE - Consider last updates as template:
- pad.lv/1637236
- pad.lv/1664478
- pad.lv/1690730
- pad.lv/1713979

Note: opening private as it is not yet announced

Revision history for this message
Christian Ehrhardt  (paelzer) wrote :

Bionic is already having 10.0-1 in proposed and will autosync 10.1-x as well as 9.6.6-1 as soon as it hits Debian (probably next week).

We are on a transition to take 9.6 out there - also Binoic is as far as possible from being released - so in this case no need to push to Bionic first for these MREs.

It would be great to have these packages prepared in proposed by then, especially since the autopkgtest queue will take a while atm - that would give it some time to build&test there.

no longer affects: postgresql-9.3 (Ubuntu Xenial)
no longer affects: postgresql-9.3 (Ubuntu Zesty)
no longer affects: postgresql-9.3 (Ubuntu Artful)
no longer affects: postgresql-9.5 (Ubuntu Trusty)
no longer affects: postgresql-9.5 (Ubuntu Zesty)
no longer affects: postgresql-9.5 (Ubuntu Artful)
no longer affects: postgresql-9.6 (Ubuntu Xenial)
no longer affects: postgresql-9.6 (Ubuntu Trusty)
Changed in postgresql-9.3 (Ubuntu):
status: New → Invalid
Changed in postgresql-9.5 (Ubuntu):
status: New → Invalid
Changed in postgresql-9.6 (Ubuntu):
status: New → Invalid
Changed in postgresql-9.6 (Ubuntu Zesty):
status: New → Triaged
Changed in postgresql-9.6 (Ubuntu Artful):
status: New → Triaged
Changed in postgresql-9.5 (Ubuntu Xenial):
status: New → Triaged
Changed in postgresql-9.3 (Ubuntu Trusty):
status: New → Triaged
Revision history for this message
Christian Ehrhardt  (paelzer) wrote :

This is (so far) based on the staging area, but that is usually ending up being
just an archive copy. So we should be good to start now.
Sniffing started in a Bileto Ticket.
- Trusty, Xenial, zesty, Artful: https://bileto.ubuntu.com/#/ticket/3029
- Bionic will be a sync once Debian picked 9.6.6-1 (and equiv to Artful)

TODO need to check the new News link like the old https://www.postgresql.org/about/news/1733 once available to check if there are important upgrade actions to take.
Announce of that will be on 9th of November.

Revision history for this message
Christian Ehrhardt  (paelzer) wrote :

So far tests hit some known issues lxd-testers and one about pgcluster setup in some tests needing to avoid blocked ports. Those are all fixed in later releases already and usually ignored on the SRU (:-/, but a tradeoff of time).

That said it seems all known good tests are good still - pushing for SRU review.

P.S. also the release is public now, so opening up the bug visibility.

information type: Private Security → Public
Changed in postgresql-10 (Ubuntu):
status: New → Fix Committed
Revision history for this message
Marc Deslauriers (mdeslaur) wrote :

These appear to fix security vulnerabilities. As such, I will release them as security updates instead of going through the SRU process.

information type: Public → Public Security
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package postgresql-9.5 - 9.5.10-0ubuntu0.16.04

---------------
postgresql-9.5 (9.5.10-0ubuntu0.16.04) xenial-security; urgency=medium

  * New upstream release (LP: #1730661)
    - Previously, a race condition allowed some table rows to be omitted from
      the index. It may be necessary to reindex existing BRIN indexes to
      recover from past occurrences of this problem.
    - Details about other changes at full changelog:
      https://www.postgresql.org/docs/9.5/static/release-9-5-10.html

 -- Christian Ehrhardt <email address hidden> Tue, 07 Nov 2017 14:33:50 +0100

Changed in postgresql-9.5 (Ubuntu Xenial):
status: Triaged → Fix Released
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package postgresql-9.6 - 9.6.6-0ubuntu0.17.10

---------------
postgresql-9.6 (9.6.6-0ubuntu0.17.10) artful-security; urgency=medium

  * New upstream release (LP: #1730661)
    - Previously, a race condition allowed some table rows to be omitted from
      the index. It may be necessary to reindex existing BRIN indexes to
      recover from past occurrences of this problem.
    - Details about other changes at full changelog:
      https://www.postgresql.org/docs/9.6/static/release-9-6-6.html

 -- Christian Ehrhardt <email address hidden> Tue, 07 Nov 2017 14:33:54 +0100

Changed in postgresql-9.6 (Ubuntu Artful):
status: Triaged → Fix Released
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package postgresql-9.3 - 9.3.20-0ubuntu0.14.04

---------------
postgresql-9.3 (9.3.20-0ubuntu0.14.04) trusty-security; urgency=medium

  * New upstream release (LP: #1730661)
    - Details about other changes at full changelog:
      https://www.postgresql.org/docs/9.3/static/release-9-3-20.html

 -- Christian Ehrhardt <email address hidden> Tue, 07 Nov 2017 14:33:47 +0100

Changed in postgresql-9.3 (Ubuntu Trusty):
status: Triaged → Fix Released
Revision history for this message
Launchpad Janitor (janitor) wrote :

This bug was fixed in the package postgresql-9.6 - 9.6.6-0ubuntu0.17.04

---------------
postgresql-9.6 (9.6.6-0ubuntu0.17.04) zesty-security; urgency=medium

  * New upstream release (LP: #1730661)
    - Previously, a race condition allowed some table rows to be omitted from
      the index. It may be necessary to reindex existing BRIN indexes to
      recover from past occurrences of this problem.
    - Details about other changes at full changelog:
      https://www.postgresql.org/docs/9.6/static/release-9-6-6.html

 -- Christian Ehrhardt <email address hidden> Tue, 07 Nov 2017 14:33:52 +0100

Changed in postgresql-9.6 (Ubuntu Zesty):
status: Triaged → Fix Released
Changed in postgresql-10 (Ubuntu):
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public Security information  
Everyone can see this security related information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.