postgresql bug fix update

Advisory:	RHBA-2005:240-04
Type:	Bug Fix Advisory
Severity:	N/A
Issued on:	2005-04-28
Last updated on:	2005-04-28
Affected Products:	Red Hat Enterprise Linux AS (v. 2.1) Red Hat Enterprise Linux ES (v. 2.1) Red Hat Enterprise Linux WS (v. 2.1) Red Hat Linux Advanced Workstation 2.1 for the Itanium Processor
OVAL:	N/A

Details

Updated postgresql packages that fix a loss-of-data scenario are now available.

PostgreSQL is an advanced Object-Relational database management system
(DBMS) that supports almost all SQL constructs (including
transactions, subselects, and user-defined types and functions).

In the original release of PostgreSQL 7.1, a certain type of possible data
corruption was treated as a PANIC-grade error, causing the server to shut
down. If this situation occurred again while trying to restart the server,
there was no way to persuade the server to start at all; yet, there
might not actually be anything wrong with the user data in the database.
The situation is rare but has been seen several times in the field. This
update allows the server to restart by downgrading the error condition to a
NOTICE when it is seen during restart.

All users who are running a PostgreSQL 7.1 server are advised to upgrade to
these updated packages. Note that the same change has already been made in
PostgreSQL 7.2 and later releases.

Solution

Before applying this update, make sure that all previously-released
errata relevant to your system have been applied. Use Red Hat
Network to download and update your packages. To launch the Red Hat
Update Agent, use the following command:

up2date

For information on how to install packages manually, refer to the
following Web page for the System Administration or Customization
guide specific to your system:

http://www.redhat.com/docs/manuals/enterprise/

Updated packages

Red Hat Enterprise Linux AS (v. 2.1)

SRPMS:
postgresql-7.1.3-7.rhel2.1AS.src.rpm	`21ce8b13043f889af1180f05643dc4b9`

IA-32:
postgresql-7.1.3-7.rhel2.1AS.i386.rpm	`6aefab7d93eea1952febd4ad1b3c265d`
postgresql-contrib-7.1.3-7.rhel2.1AS.i386.rpm	`ad073fde582cab8808982a486d50bc23`
postgresql-devel-7.1.3-7.rhel2.1AS.i386.rpm	`d4938615c4a67020a23f6ef9c5679daf`
postgresql-docs-7.1.3-7.rhel2.1AS.i386.rpm	`5534f7fb31e8aedee806eb21c2d31577`
postgresql-jdbc-7.1.3-7.rhel2.1AS.i386.rpm	`eaf9b52a35628331c562994211e00f16`
postgresql-libs-7.1.3-7.rhel2.1AS.i386.rpm	`333b94c0ea7e11a9cf67d3e9d15f5e2b`
postgresql-odbc-7.1.3-7.rhel2.1AS.i386.rpm	`46ab4c1c5c47a3628d3f16c6dbb8d29d`
postgresql-perl-7.1.3-7.rhel2.1AS.i386.rpm	`0a4956d8776922182d8c8ee37de2422b`
postgresql-python-7.1.3-7.rhel2.1AS.i386.rpm	`57075e6b4bb64a5f5a57a54a5b3e6e21`
postgresql-server-7.1.3-7.rhel2.1AS.i386.rpm	`f1a6382e4ff81ee43ed657474128748b`
postgresql-tcl-7.1.3-7.rhel2.1AS.i386.rpm	`81b815e75e50c21449ea95ba59d05fc2`
postgresql-test-7.1.3-7.rhel2.1AS.i386.rpm	`39bf55cc372ea97e23d5f74c10d35332`
postgresql-tk-7.1.3-7.rhel2.1AS.i386.rpm	`c93c84fd8265e594884a8e4bc07513d6`

IA-64:
postgresql-7.1.3-7.rhel2.1AS.ia64.rpm	`82ac6b978c9326b563753f7467222561`
postgresql-contrib-7.1.3-7.rhel2.1AS.ia64.rpm	`c7f2b040b44cafab301d27eb4fabc361`
postgresql-devel-7.1.3-7.rhel2.1AS.ia64.rpm	`5c854107732f5c35e4fa2c108d261c1b`
postgresql-docs-7.1.3-7.rhel2.1AS.ia64.rpm	`f1de63a20e3f2a05aea793be1aedebd3`
postgresql-jdbc-7.1.3-7.rhel2.1AS.ia64.rpm	`9298abf8efb45a271c8da39ec8891bc6`
postgresql-libs-7.1.3-7.rhel2.1AS.ia64.rpm	`6e2b088b1dbe14087c93dad3becb5f2f`
postgresql-odbc-7.1.3-7.rhel2.1AS.ia64.rpm	`dd6dd32ff9af69d637c152318f7f2813`
postgresql-perl-7.1.3-7.rhel2.1AS.ia64.rpm	`272c8141670f302f074b561fb38b824c`
postgresql-python-7.1.3-7.rhel2.1AS.ia64.rpm	`9e6c482caec304bb47df28355290cfc9`
postgresql-server-7.1.3-7.rhel2.1AS.ia64.rpm	`2e01ad190803761e6a1ffe2f36950a71`
postgresql-tcl-7.1.3-7.rhel2.1AS.ia64.rpm	`5f75a1d02d0a7051a80fe6aeaf27cf8a`
postgresql-test-7.1.3-7.rhel2.1AS.ia64.rpm	`1170abeeb701569a74dde63a938bbd19`
postgresql-tk-7.1.3-7.rhel2.1AS.ia64.rpm	`40695d79ef16fcbdff530d7e2821efca`

Red Hat Enterprise Linux ES (v. 2.1)

SRPMS:
postgresql-7.1.3-7.rhel2.1AS.src.rpm	`21ce8b13043f889af1180f05643dc4b9`

IA-32:
postgresql-7.1.3-7.rhel2.1AS.i386.rpm	`6aefab7d93eea1952febd4ad1b3c265d`
postgresql-contrib-7.1.3-7.rhel2.1AS.i386.rpm	`ad073fde582cab8808982a486d50bc23`
postgresql-devel-7.1.3-7.rhel2.1AS.i386.rpm	`d4938615c4a67020a23f6ef9c5679daf`
postgresql-docs-7.1.3-7.rhel2.1AS.i386.rpm	`5534f7fb31e8aedee806eb21c2d31577`
postgresql-jdbc-7.1.3-7.rhel2.1AS.i386.rpm	`eaf9b52a35628331c562994211e00f16`
postgresql-libs-7.1.3-7.rhel2.1AS.i386.rpm	`333b94c0ea7e11a9cf67d3e9d15f5e2b`
postgresql-odbc-7.1.3-7.rhel2.1AS.i386.rpm	`46ab4c1c5c47a3628d3f16c6dbb8d29d`
postgresql-perl-7.1.3-7.rhel2.1AS.i386.rpm	`0a4956d8776922182d8c8ee37de2422b`
postgresql-python-7.1.3-7.rhel2.1AS.i386.rpm	`57075e6b4bb64a5f5a57a54a5b3e6e21`
postgresql-server-7.1.3-7.rhel2.1AS.i386.rpm	`f1a6382e4ff81ee43ed657474128748b`
postgresql-tcl-7.1.3-7.rhel2.1AS.i386.rpm	`81b815e75e50c21449ea95ba59d05fc2`
postgresql-test-7.1.3-7.rhel2.1AS.i386.rpm	`39bf55cc372ea97e23d5f74c10d35332`
postgresql-tk-7.1.3-7.rhel2.1AS.i386.rpm	`c93c84fd8265e594884a8e4bc07513d6`

Red Hat Enterprise Linux WS (v. 2.1)

SRPMS:
postgresql-7.1.3-7.rhel2.1AS.src.rpm	`21ce8b13043f889af1180f05643dc4b9`

IA-32:
postgresql-7.1.3-7.rhel2.1AS.i386.rpm	`6aefab7d93eea1952febd4ad1b3c265d`
postgresql-contrib-7.1.3-7.rhel2.1AS.i386.rpm	`ad073fde582cab8808982a486d50bc23`
postgresql-devel-7.1.3-7.rhel2.1AS.i386.rpm	`d4938615c4a67020a23f6ef9c5679daf`
postgresql-docs-7.1.3-7.rhel2.1AS.i386.rpm	`5534f7fb31e8aedee806eb21c2d31577`
postgresql-jdbc-7.1.3-7.rhel2.1AS.i386.rpm	`eaf9b52a35628331c562994211e00f16`
postgresql-libs-7.1.3-7.rhel2.1AS.i386.rpm	`333b94c0ea7e11a9cf67d3e9d15f5e2b`
postgresql-odbc-7.1.3-7.rhel2.1AS.i386.rpm	`46ab4c1c5c47a3628d3f16c6dbb8d29d`
postgresql-perl-7.1.3-7.rhel2.1AS.i386.rpm	`0a4956d8776922182d8c8ee37de2422b`
postgresql-python-7.1.3-7.rhel2.1AS.i386.rpm	`57075e6b4bb64a5f5a57a54a5b3e6e21`
postgresql-server-7.1.3-7.rhel2.1AS.i386.rpm	`f1a6382e4ff81ee43ed657474128748b`
postgresql-tcl-7.1.3-7.rhel2.1AS.i386.rpm	`81b815e75e50c21449ea95ba59d05fc2`
postgresql-test-7.1.3-7.rhel2.1AS.i386.rpm	`39bf55cc372ea97e23d5f74c10d35332`
postgresql-tk-7.1.3-7.rhel2.1AS.i386.rpm	`c93c84fd8265e594884a8e4bc07513d6`

Red Hat Linux Advanced Workstation 2.1 for the Itanium Processor

SRPMS:
postgresql-7.1.3-7.rhel2.1AS.src.rpm	`21ce8b13043f889af1180f05643dc4b9`

IA-64:
postgresql-7.1.3-7.rhel2.1AS.ia64.rpm	`82ac6b978c9326b563753f7467222561`
postgresql-contrib-7.1.3-7.rhel2.1AS.ia64.rpm	`c7f2b040b44cafab301d27eb4fabc361`
postgresql-devel-7.1.3-7.rhel2.1AS.ia64.rpm	`5c854107732f5c35e4fa2c108d261c1b`
postgresql-docs-7.1.3-7.rhel2.1AS.ia64.rpm	`f1de63a20e3f2a05aea793be1aedebd3`
postgresql-jdbc-7.1.3-7.rhel2.1AS.ia64.rpm	`9298abf8efb45a271c8da39ec8891bc6`
postgresql-libs-7.1.3-7.rhel2.1AS.ia64.rpm	`6e2b088b1dbe14087c93dad3becb5f2f`
postgresql-odbc-7.1.3-7.rhel2.1AS.ia64.rpm	`dd6dd32ff9af69d637c152318f7f2813`
postgresql-perl-7.1.3-7.rhel2.1AS.ia64.rpm	`272c8141670f302f074b561fb38b824c`
postgresql-python-7.1.3-7.rhel2.1AS.ia64.rpm	`9e6c482caec304bb47df28355290cfc9`
postgresql-server-7.1.3-7.rhel2.1AS.ia64.rpm	`2e01ad190803761e6a1ffe2f36950a71`
postgresql-tcl-7.1.3-7.rhel2.1AS.ia64.rpm	`5f75a1d02d0a7051a80fe6aeaf27cf8a`
postgresql-test-7.1.3-7.rhel2.1AS.ia64.rpm	`1170abeeb701569a74dde63a938bbd19`
postgresql-tk-7.1.3-7.rhel2.1AS.ia64.rpm	`40695d79ef16fcbdff530d7e2821efca`

(The unlinked packages above are only available from the Red Hat Network)

Bugs fixed (see bugzilla for more information)

149760 - PostgreSQL 7.1 won't restart if it encounters corrupt data

These packages are GPG signed by Red Hat for security. Our key and details on how to verify the signature are available from:
https://www.redhat.com/security/team/key/#package

The Red Hat security contact is secalert@redhat.com. More contact details at http://www.redhat.com/security/team/contact/