Description of problem: Transactions committed just before the last checkpoint before a database crash may be lost, in whole or in part, after recovery. Version-Release number of selected component (if applicable): All PG versions 7.1-7.4 How reproducible: Difficult to reproduce due to narrow window of vulnerability, but a fairly reproducible test case is described at http://archives.postgresql.org/pgsql-hackers/2004-08/msg00650.php Steps to Reproduce: 1. See link Actual results: Lost data Expected results: No lost data Additional info: This is repaired in the most recent upstream releases. For RHEL3, we are using the 7.3 series of PG releases, so we should update to PG 7.3.7 to fix this.
rh-postgresql-7.3.7-1 has been built for RHEL3 U4.
An errata has been issued which should help the problem described in this bug report. This report is therefore being closed with a resolution of ERRATA. For more information on the solution and/or where to find the updated files, please follow the link below. You may reopen this bug report if the solution does not work for you. http://rhn.redhat.com/errata/RHSA-2004-489.html