Issued:

2012-05-21

Updated:

2012-05-21

RHSA-2012:0677 - 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 5.

The Red Hat Security Response Team has rated this update as having moderate security impact. Common Vulnerability Scoring System (CVSS) base scores, which give detailed severity ratings, are available for each vulnerability from the CVE links in the References section.

Description

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

The pg_dump utility inserted object names literally into comments in the SQL script it produces. An unprivileged database user could create an object whose name includes a newline followed by an SQL command. This SQL command might then be executed by a privileged user during later restore of the backup dump, allowing privilege escalation. (CVE-2012-0868)

CREATE TRIGGER did not do a permissions check on the trigger function to be called. This could possibly allow an authenticated database user to call a privileged trigger function on data of their choosing. (CVE-2012-0866)

All PostgreSQL users are advised to upgrade to these updated packages, which contain backported patches to correct these issues. If the postgresql service is running, it will be automatically restarted after installing this update.

Solution

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

This update is available via the Red Hat Network. Details on how to use the Red Hat Network to apply this update are available at https://access.redhat.com/knowledge/articles/11258

Affected Products

Updated Packages

• postgresql-test-8.1.23-4.el5_8.i386.rpm
• postgresql-test-8.1.23-4.el5_8.x86_64.rpm
• postgresql-8.1.23-4.el5_8.src.rpm
• postgresql-debuginfo-8.1.23-4.el5_8.s390x.rpm
• postgresql-tcl-8.1.23-4.el5_8.s390x.rpm
• postgresql-tcl-8.1.23-4.el5_8.ia64.rpm
• postgresql-8.1.23-4.el5_8.ia64.rpm
• postgresql-debuginfo-8.1.23-4.el5_8.i386.rpm
• postgresql-python-8.1.23-4.el5_8.x86_64.rpm
• postgresql-8.1.23-4.el5_8.i386.rpm
• postgresql-docs-8.1.23-4.el5_8.ia64.rpm
• postgresql-libs-8.1.23-4.el5_8.x86_64.rpm
• postgresql-pl-8.1.23-4.el5_8.ppc.rpm
• postgresql-python-8.1.23-4.el5_8.ppc.rpm
• postgresql-server-8.1.23-4.el5_8.i386.rpm
• postgresql-python-8.1.23-4.el5_8.s390x.rpm
• postgresql-tcl-8.1.23-4.el5_8.x86_64.rpm
• postgresql-debuginfo-8.1.23-4.el5_8.x86_64.rpm
• postgresql-debuginfo-8.1.23-4.el5_8.s390.rpm
• postgresql-pl-8.1.23-4.el5_8.ia64.rpm
• postgresql-docs-8.1.23-4.el5_8.i386.rpm
• postgresql-libs-8.1.23-4.el5_8.ppc.rpm
• postgresql-contrib-8.1.23-4.el5_8.s390x.rpm
• postgresql-devel-8.1.23-4.el5_8.ia64.rpm
• postgresql-tcl-8.1.23-4.el5_8.i386.rpm
• postgresql-server-8.1.23-4.el5_8.ia64.rpm
• postgresql-pl-8.1.23-4.el5_8.x86_64.rpm
• postgresql-8.1.23-4.el5_8.ppc.rpm
• postgresql-test-8.1.23-4.el5_8.ppc.rpm
• postgresql-libs-8.1.23-4.el5_8.s390x.rpm
• postgresql-libs-8.1.23-4.el5_8.ia64.rpm
• postgresql-devel-8.1.23-4.el5_8.ppc64.rpm
• postgresql-devel-8.1.23-4.el5_8.i386.rpm
• postgresql-test-8.1.23-4.el5_8.ia64.rpm
• postgresql-contrib-8.1.23-4.el5_8.ppc.rpm
• postgresql-devel-8.1.23-4.el5_8.s390x.rpm
• postgresql-python-8.1.23-4.el5_8.ia64.rpm
• postgresql-pl-8.1.23-4.el5_8.s390x.rpm
• postgresql-debuginfo-8.1.23-4.el5_8.ppc64.rpm
• postgresql-docs-8.1.23-4.el5_8.s390x.rpm
• postgresql-debuginfo-8.1.23-4.el5_8.ia64.rpm
• postgresql-server-8.1.23-4.el5_8.s390x.rpm
• postgresql-server-8.1.23-4.el5_8.ppc.rpm
• postgresql-devel-8.1.23-4.el5_8.s390.rpm
• postgresql-contrib-8.1.23-4.el5_8.ia64.rpm
• postgresql-pl-8.1.23-4.el5_8.i386.rpm
• postgresql-test-8.1.23-4.el5_8.s390x.rpm
• postgresql-docs-8.1.23-4.el5_8.x86_64.rpm
• postgresql-8.1.23-4.el5_8.x86_64.rpm
• postgresql-libs-8.1.23-4.el5_8.i386.rpm
• postgresql-docs-8.1.23-4.el5_8.ppc.rpm
• postgresql-devel-8.1.23-4.el5_8.x86_64.rpm
• postgresql-libs-8.1.23-4.el5_8.s390.rpm
• postgresql-python-8.1.23-4.el5_8.i386.rpm
• postgresql-server-8.1.23-4.el5_8.x86_64.rpm
• postgresql-tcl-8.1.23-4.el5_8.ppc.rpm
• postgresql-debuginfo-8.1.23-4.el5_8.ppc.rpm
• postgresql-contrib-8.1.23-4.el5_8.i386.rpm
• postgresql-8.1.23-4.el5_8.ppc64.rpm
• postgresql-contrib-8.1.23-4.el5_8.x86_64.rpm
• postgresql-libs-8.1.23-4.el5_8.ppc64.rpm
• postgresql-8.1.23-4.el5_8.s390x.rpm
• postgresql-devel-8.1.23-4.el5_8.ppc.rpm

Fixes

• This content is not included.BZ - 797222
• This content is not included.BZ - 797917

CVEs

• CVE-2012-0866
• CVE-2012-0868

References

• https://access.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.