* New upstream bug fix release (LP: #1637236)
- Fix WAL-logging of truncation of relation free space maps and visibility
maps.
It was possible for these files to not be correctly restored during
crash recovery, or to be written incorrectly on a standby server. Bogus
entries in a free space map could lead to attempts to access pages that
have been truncated away from the relation itself, typically producing
errors like "could not read block XXX: read only 0 of 8192 bytes".
Checksum failures in the visibility map are also possible, if
checksumming is enabled.
This bug was fixed in the package postgresql-9.5 - 9.5.5-0ubuntu1
---------------
postgresql-9.5 (9.5.5-0ubuntu1) zesty-proposed; urgency=medium
* New upstream bug fix release (LP: #1637236)
- Fix WAL-logging of truncation of relation free space maps and visibility
maps.
It was possible for these files to not be correctly restored during
crash recovery, or to be written incorrectly on a standby server. Bogus
entries in a free space map could lead to attempts to access pages that
have been truncated away from the relation itself, typically producing
errors like "could not read block XXX: read only 0 of 8192 bytes".
Checksum failures in the visibility map are also possible, if
checksumming is enabled.
Procedures for determining whether there is a problem and repairing it /wiki.postgresq l.org/wiki/ Free_Space_ Map_Problems.
if so are discussed at
https:/
- Details about other changes: www.postgresql. org/docs/ 9.5/static/ release- 9-5-5.html
http://
-- Martin Pitt <email address hidden> Thu, 27 Oct 2016 17:51:11 +0200