Issued:

2009-10-07

Updated:

2009-10-07

RHSA-2009:1484 - Moderate: postgresql security update

Synopsis

Moderate: postgresql security update

Type/Severity

Security Advisory Moderate

Topic

Updated postgresql packages that fix two security issues are now available for Red Hat Enterprise Linux 4 and 5.

This update has been rated as having moderate security impact by the Red Hat Security Response Team.

Description

PostgreSQL is an advanced object-relational database management system (DBMS).

It was discovered that the upstream patch for CVE-2007-6600 included in the Red Hat Security Advisory RHSA-2008:0038 did not include protection against misuse of the RESET ROLE and RESET SESSION AUTHORIZATION commands. An authenticated user could use this flaw to install malicious code that would later execute with superuser privileges. (CVE-2009-3230)

A flaw was found in the way PostgreSQL handled encoding conversion. A remote, authenticated user could trigger an encoding conversion failure, possibly leading to a temporary denial of service. Note: To exploit this issue, a locale and client encoding for which specific messages fail to translate must be selected (the availability of these is determined by an administrator-defined locale setting). (CVE-2009-0922)

Note: For Red Hat Enterprise Linux 4, this update upgrades PostgreSQL to version 7.4.26. For Red Hat Enterprise Linux 5, this update upgrades PostgreSQL to version 8.1.18. Refer to the PostgreSQL Release Notes for a list of changes:

Content from www.postgresql.org is not included.http://www.postgresql.org/docs/7.4/static/release.html Content from www.postgresql.org is not included.http://www.postgresql.org/docs/8.1/static/release.html

All PostgreSQL users should upgrade to these updated packages, which resolve these issues. If the postgresql service is running, it will be automatically restarted after installing this update.

Solution

Before applying this update, make sure that all previously-released errata relevant to your system have been applied.

This update is available via Red Hat Network. Details on how to use the Red Hat Network to apply this update are available at This content is not included.http://kbase.redhat.com/faq/docs/DOC-11259

Affected Products

Updated Packages

• postgresql-contrib-8.1.18-2.el5_4.1.s390x.rpm
• postgresql-7.4.26-1.el4_8.1.src.rpm
• postgresql-pl-7.4.26-1.el4_8.1.x86_64.rpm
• postgresql-server-7.4.26-1.el4_8.1.s390.rpm
• postgresql-devel-8.1.18-2.el5_4.1.s390x.rpm
• postgresql-server-8.1.18-2.el5_4.1.s390x.rpm
• postgresql-python-8.1.18-2.el5_4.1.ppc.rpm
• postgresql-devel-8.1.18-2.el5_4.1.ia64.rpm
• postgresql-contrib-7.4.26-1.el4_8.1.i386.rpm
• postgresql-contrib-7.4.26-1.el4_8.1.x86_64.rpm
• postgresql-7.4.26-1.el4_8.1.ia64.rpm
• postgresql-8.1.18-2.el5_4.1.i386.rpm
• postgresql-pl-7.4.26-1.el4_8.1.ia64.rpm
• postgresql-test-8.1.18-2.el5_4.1.s390x.rpm
• postgresql-docs-7.4.26-1.el4_8.1.ppc.rpm
• postgresql-python-7.4.26-1.el4_8.1.s390x.rpm
• postgresql-test-8.1.18-2.el5_4.1.x86_64.rpm
• postgresql-python-8.1.18-2.el5_4.1.ia64.rpm
• postgresql-docs-7.4.26-1.el4_8.1.s390x.rpm
• postgresql-jdbc-7.4.26-1.el4_8.1.ppc.rpm
• postgresql-devel-7.4.26-1.el4_8.1.ia64.rpm
• postgresql-server-7.4.26-1.el4_8.1.i386.rpm
• postgresql-docs-8.1.18-2.el5_4.1.x86_64.rpm
• postgresql-libs-8.1.18-2.el5_4.1.ppc.rpm
• postgresql-tcl-7.4.26-1.el4_8.1.s390.rpm
• postgresql-server-7.4.26-1.el4_8.1.x86_64.rpm
• postgresql-jdbc-7.4.26-1.el4_8.1.s390x.rpm
• postgresql-python-7.4.26-1.el4_8.1.i386.rpm
• postgresql-libs-7.4.26-1.el4_8.1.s390.rpm
• postgresql-8.1.18-2.el5_4.1.ppc.rpm
• postgresql-python-7.4.26-1.el4_8.1.s390.rpm
• postgresql-jdbc-7.4.26-1.el4_8.1.ia64.rpm
• postgresql-8.1.18-2.el5_4.1.ia64.rpm
• postgresql-pl-8.1.18-2.el5_4.1.i386.rpm
• postgresql-tcl-7.4.26-1.el4_8.1.ppc.rpm
• postgresql-libs-7.4.26-1.el4_8.1.ppc64.rpm
• postgresql-test-7.4.26-1.el4_8.1.ppc.rpm
• postgresql-pl-7.4.26-1.el4_8.1.s390x.rpm
• postgresql-docs-8.1.18-2.el5_4.1.s390x.rpm
• postgresql-pl-8.1.18-2.el5_4.1.x86_64.rpm
• postgresql-tcl-7.4.26-1.el4_8.1.ia64.rpm
• postgresql-devel-8.1.18-2.el5_4.1.ppc.rpm
• postgresql-8.1.18-2.el5_4.1.x86_64.rpm
• postgresql-devel-7.4.26-1.el4_8.1.x86_64.rpm
• postgresql-libs-7.4.26-1.el4_8.1.s390x.rpm
• postgresql-pl-7.4.26-1.el4_8.1.i386.rpm
• postgresql-test-7.4.26-1.el4_8.1.x86_64.rpm
• postgresql-8.1.18-2.el5_4.1.s390x.rpm
• postgresql-7.4.26-1.el4_8.1.ppc.rpm
• postgresql-libs-8.1.18-2.el5_4.1.x86_64.rpm
• postgresql-server-7.4.26-1.el4_8.1.ppc.rpm
• postgresql-server-8.1.18-2.el5_4.1.x86_64.rpm
• postgresql-docs-8.1.18-2.el5_4.1.i386.rpm
• postgresql-jdbc-7.4.26-1.el4_8.1.s390.rpm
• postgresql-docs-7.4.26-1.el4_8.1.ia64.rpm
• postgresql-tcl-7.4.26-1.el4_8.1.s390x.rpm
• postgresql-server-7.4.26-1.el4_8.1.s390x.rpm
• postgresql-python-8.1.18-2.el5_4.1.i386.rpm
• postgresql-python-7.4.26-1.el4_8.1.x86_64.rpm
• postgresql-contrib-8.1.18-2.el5_4.1.ppc.rpm
• postgresql-test-7.4.26-1.el4_8.1.ia64.rpm
• postgresql-libs-8.1.18-2.el5_4.1.i386.rpm
• postgresql-8.1.18-2.el5_4.1.src.rpm
• postgresql-tcl-7.4.26-1.el4_8.1.x86_64.rpm
• postgresql-server-7.4.26-1.el4_8.1.ia64.rpm
• postgresql-tcl-7.4.26-1.el4_8.1.i386.rpm
• postgresql-7.4.26-1.el4_8.1.s390.rpm
• postgresql-devel-7.4.26-1.el4_8.1.s390x.rpm
• postgresql-pl-8.1.18-2.el5_4.1.s390x.rpm
• postgresql-devel-7.4.26-1.el4_8.1.i386.rpm
• postgresql-devel-8.1.18-2.el5_4.1.x86_64.rpm
• postgresql-server-8.1.18-2.el5_4.1.ppc.rpm
• postgresql-docs-7.4.26-1.el4_8.1.x86_64.rpm
• postgresql-libs-8.1.18-2.el5_4.1.ppc64.rpm
• postgresql-test-8.1.18-2.el5_4.1.ppc.rpm
• postgresql-7.4.26-1.el4_8.1.i386.rpm
• postgresql-docs-8.1.18-2.el5_4.1.ppc.rpm
• postgresql-tcl-8.1.18-2.el5_4.1.s390x.rpm
• postgresql-devel-7.4.26-1.el4_8.1.ppc.rpm
• postgresql-tcl-8.1.18-2.el5_4.1.i386.rpm
• postgresql-8.1.18-2.el5_4.1.ppc64.rpm
• postgresql-7.4.26-1.el4_8.1.x86_64.rpm
• postgresql-docs-8.1.18-2.el5_4.1.ia64.rpm
• postgresql-libs-7.4.26-1.el4_8.1.x86_64.rpm
• postgresql-test-7.4.26-1.el4_8.1.s390x.rpm
• postgresql-7.4.26-1.el4_8.1.s390x.rpm
• postgresql-jdbc-7.4.26-1.el4_8.1.x86_64.rpm
• postgresql-contrib-7.4.26-1.el4_8.1.s390.rpm
• postgresql-tcl-8.1.18-2.el5_4.1.ia64.rpm
• postgresql-jdbc-7.4.26-1.el4_8.1.i386.rpm
• postgresql-devel-8.1.18-2.el5_4.1.ppc64.rpm
• postgresql-libs-8.1.18-2.el5_4.1.s390.rpm
• postgresql-libs-7.4.26-1.el4_8.1.i386.rpm
• postgresql-contrib-7.4.26-1.el4_8.1.ia64.rpm
• postgresql-contrib-7.4.26-1.el4_8.1.ppc.rpm
• postgresql-contrib-8.1.18-2.el5_4.1.i386.rpm
• postgresql-test-8.1.18-2.el5_4.1.ia64.rpm
• postgresql-libs-8.1.18-2.el5_4.1.ia64.rpm
• postgresql-pl-8.1.18-2.el5_4.1.ia64.rpm
• postgresql-pl-7.4.26-1.el4_8.1.ppc.rpm
• postgresql-pl-7.4.26-1.el4_8.1.s390.rpm
• postgresql-devel-8.1.18-2.el5_4.1.s390.rpm
• postgresql-contrib-8.1.18-2.el5_4.1.x86_64.rpm
• postgresql-server-8.1.18-2.el5_4.1.i386.rpm
• postgresql-contrib-8.1.18-2.el5_4.1.ia64.rpm
• postgresql-pl-8.1.18-2.el5_4.1.ppc.rpm
• postgresql-devel-8.1.18-2.el5_4.1.i386.rpm
• postgresql-libs-8.1.18-2.el5_4.1.s390x.rpm
• postgresql-server-8.1.18-2.el5_4.1.ia64.rpm
• postgresql-test-7.4.26-1.el4_8.1.s390.rpm
• postgresql-docs-7.4.26-1.el4_8.1.s390.rpm
• postgresql-docs-7.4.26-1.el4_8.1.i386.rpm
• postgresql-contrib-7.4.26-1.el4_8.1.s390x.rpm
• postgresql-python-8.1.18-2.el5_4.1.s390x.rpm
• postgresql-tcl-8.1.18-2.el5_4.1.x86_64.rpm
• postgresql-python-7.4.26-1.el4_8.1.ia64.rpm
• postgresql-test-8.1.18-2.el5_4.1.i386.rpm
• postgresql-devel-7.4.26-1.el4_8.1.s390.rpm
• postgresql-test-7.4.26-1.el4_8.1.i386.rpm
• postgresql-tcl-8.1.18-2.el5_4.1.ppc.rpm
• postgresql-python-8.1.18-2.el5_4.1.x86_64.rpm
• postgresql-libs-7.4.26-1.el4_8.1.ia64.rpm
• postgresql-libs-7.4.26-1.el4_8.1.ppc.rpm
• postgresql-python-7.4.26-1.el4_8.1.ppc.rpm

Fixes

• This content is not included.BZ - 488156
• This content is not included.BZ - 522085

CVEs

• CVE-2009-0922
• CVE-2009-3230

References

• http://www.redhat.com/security/updates/classification/#moderate

Additional information

• The Red Hat security contact is This content is not included.secalert@redhat.com. More contact details at https://access.redhat.com/security/team/contact/.
• Offline Security Data data is available for integration with other systems. See Offline Security Data API to get started.