Issued:

2010-10-06

Updated:

2010-10-06

RHSA-2010:0742 - Moderate: postgresql and postgresql84 security update

Synopsis

Moderate: postgresql and postgresql84 security update

Type/Severity

Security Advisory Moderate

Topic

Updated postgresql and postgresql84 packages that fix one security issue are now available for Red Hat Enterprise Linux 4 and 5.

The Red Hat Security Response Team has rated this update as having moderate security impact. A Common Vulnerability Scoring System (CVSS) base score, which gives a detailed severity rating, is available from the CVE link in the References section.

Description

PostgreSQL is an advanced object-relational database management system (DBMS). PL/Perl and PL/Tcl allow users to write PostgreSQL functions in the Perl and Tcl languages. The PostgreSQL SECURITY DEFINER parameter, which can be used when creating a new PostgreSQL function, specifies that the function will be executed with the privileges of the user that created it.

It was discovered that a user could utilize the features of the PL/Perl and PL/Tcl languages to modify the behavior of a SECURITY DEFINER function created by a different user. If the PL/Perl or PL/Tcl language was used to implement a SECURITY DEFINER function, an authenticated database user could use a PL/Perl or PL/Tcl script to modify the behavior of that function during subsequent calls in the same session. This would result in the modified or injected code also being executed with the privileges of the user who created the SECURITY DEFINER function, possibly leading to privilege escalation. (CVE-2010-3433)

For Red Hat Enterprise Linux 4, the updated postgresql packages upgrade PostgreSQL to version 7.4.30. 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

For Red Hat Enterprise Linux 5, the updated postgresql packages upgrade PostgreSQL to version 8.1.22, and the updated postgresql84 packages upgrade PostgreSQL to version 8.4.5. Refer to the PostgreSQL Release Notes for a list of changes:

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

All PostgreSQL users are advised to upgrade to these updated packages, which correct this issue. 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 This content is not included.http://kbase.redhat.com/faq/docs/DOC-11259

Affected Products

Updated Packages

• postgresql84-test-8.4.5-1.el5_5.1.ppc.rpm
• postgresql84-plperl-8.4.5-1.el5_5.1.x86_64.rpm
• postgresql-test-8.1.22-1.el5_5.1.x86_64.rpm
• postgresql84-docs-8.4.5-1.el5_5.1.s390x.rpm
• postgresql84-pltcl-8.4.5-1.el5_5.1.x86_64.rpm
• postgresql84-tcl-8.4.5-1.el5_5.1.ia64.rpm
• postgresql84-plpython-8.4.5-1.el5_5.1.i386.rpm
• postgresql-devel-7.4.30-1.el4_8.1.ppc.rpm
• postgresql84-8.4.5-1.el5_5.1.ppc.rpm
• postgresql84-devel-8.4.5-1.el5_5.1.ia64.rpm
• postgresql-devel-8.1.22-1.el5_5.1.ppc64.rpm
• postgresql-devel-8.1.22-1.el5_5.1.ppc.rpm
• postgresql84-tcl-8.4.5-1.el5_5.1.i386.rpm
• postgresql-libs-8.1.22-1.el5_5.1.i386.rpm
• postgresql-python-8.1.22-1.el5_5.1.i386.rpm
• postgresql-docs-7.4.30-1.el4_8.1.s390x.rpm
• postgresql-python-7.4.30-1.el4_8.1.i386.rpm
• postgresql-python-8.1.22-1.el5_5.1.s390x.rpm
• postgresql84-test-8.4.5-1.el5_5.1.s390x.rpm
• postgresql-docs-7.4.30-1.el4_8.1.ia64.rpm
• postgresql-pl-7.4.30-1.el4_8.1.ia64.rpm
• postgresql84-test-8.4.5-1.el5_5.1.i386.rpm
• postgresql84-devel-8.4.5-1.el5_5.1.x86_64.rpm
• postgresql-pl-8.1.22-1.el5_5.1.ia64.rpm
• postgresql-tcl-8.1.22-1.el5_5.1.ppc.rpm
• postgresql-test-7.4.30-1.el4_8.1.i386.rpm
• postgresql-tcl-7.4.30-1.el4_8.1.x86_64.rpm
• postgresql-server-7.4.30-1.el4_8.1.ia64.rpm
• postgresql-libs-8.1.22-1.el5_5.1.ia64.rpm
• postgresql84-pltcl-8.4.5-1.el5_5.1.s390x.rpm
• postgresql-python-8.1.22-1.el5_5.1.ia64.rpm
• postgresql-server-8.1.22-1.el5_5.1.x86_64.rpm
• postgresql-contrib-7.4.30-1.el4_8.1.s390x.rpm
• postgresql-docs-7.4.30-1.el4_8.1.ppc.rpm
• postgresql-7.4.30-1.el4_8.1.s390.rpm
• postgresql-8.1.22-1.el5_5.1.ia64.rpm
• postgresql-contrib-7.4.30-1.el4_8.1.x86_64.rpm
• postgresql84-libs-8.4.5-1.el5_5.1.i386.rpm
• postgresql-python-7.4.30-1.el4_8.1.x86_64.rpm
• postgresql84-plperl-8.4.5-1.el5_5.1.i386.rpm
• postgresql-libs-8.1.22-1.el5_5.1.ppc.rpm
• postgresql-jdbc-7.4.30-1.el4_8.1.s390.rpm
• postgresql84-python-8.4.5-1.el5_5.1.x86_64.rpm
• postgresql-8.1.22-1.el5_5.1.ppc64.rpm
• postgresql84-docs-8.4.5-1.el5_5.1.ppc.rpm
• postgresql-tcl-8.1.22-1.el5_5.1.ia64.rpm
• postgresql-devel-7.4.30-1.el4_8.1.ia64.rpm
• postgresql-7.4.30-1.el4_8.1.src.rpm
• postgresql-jdbc-7.4.30-1.el4_8.1.s390x.rpm
• postgresql84-python-8.4.5-1.el5_5.1.ia64.rpm
• postgresql-libs-7.4.30-1.el4_8.1.ppc.rpm
• postgresql-7.4.30-1.el4_8.1.s390x.rpm
• postgresql84-8.4.5-1.el5_5.1.x86_64.rpm
• postgresql84-contrib-8.4.5-1.el5_5.1.x86_64.rpm
• postgresql-docs-8.1.22-1.el5_5.1.ppc.rpm
• postgresql84-tcl-8.4.5-1.el5_5.1.x86_64.rpm
• postgresql-test-8.1.22-1.el5_5.1.ppc.rpm
• postgresql-contrib-8.1.22-1.el5_5.1.ia64.rpm
• postgresql84-plpython-8.4.5-1.el5_5.1.ia64.rpm
• postgresql84-test-8.4.5-1.el5_5.1.ia64.rpm
• postgresql-docs-8.1.22-1.el5_5.1.x86_64.rpm
• postgresql84-tcl-8.4.5-1.el5_5.1.ppc.rpm
• postgresql-tcl-7.4.30-1.el4_8.1.i386.rpm
• postgresql84-devel-8.4.5-1.el5_5.1.s390x.rpm
• postgresql84-plperl-8.4.5-1.el5_5.1.s390x.rpm
• postgresql-server-7.4.30-1.el4_8.1.x86_64.rpm
• postgresql-python-7.4.30-1.el4_8.1.s390.rpm
• postgresql-docs-8.1.22-1.el5_5.1.s390x.rpm
• postgresql-libs-7.4.30-1.el4_8.1.s390x.rpm
• postgresql-python-8.1.22-1.el5_5.1.x86_64.rpm
• postgresql84-8.4.5-1.el5_5.1.s390x.rpm
• postgresql-libs-7.4.30-1.el4_8.1.s390.rpm
• postgresql-test-7.4.30-1.el4_8.1.ppc.rpm
• postgresql-contrib-8.1.22-1.el5_5.1.i386.rpm
• postgresql84-plpython-8.4.5-1.el5_5.1.s390x.rpm
• postgresql-8.1.22-1.el5_5.1.ppc.rpm
• postgresql84-devel-8.4.5-1.el5_5.1.i386.rpm
• postgresql84-contrib-8.4.5-1.el5_5.1.i386.rpm
• postgresql-devel-7.4.30-1.el4_8.1.i386.rpm
• postgresql84-devel-8.4.5-1.el5_5.1.ppc64.rpm
• postgresql-contrib-7.4.30-1.el4_8.1.s390.rpm
• postgresql84-server-8.4.5-1.el5_5.1.i386.rpm
• postgresql84-pltcl-8.4.5-1.el5_5.1.ppc.rpm
• postgresql-python-8.1.22-1.el5_5.1.ppc.rpm
• postgresql84-server-8.4.5-1.el5_5.1.ppc.rpm
• postgresql84-plperl-8.4.5-1.el5_5.1.ppc.rpm
• postgresql84-server-8.4.5-1.el5_5.1.x86_64.rpm
• postgresql-devel-8.1.22-1.el5_5.1.ia64.rpm
• postgresql-server-8.1.22-1.el5_5.1.ia64.rpm
• postgresql84-libs-8.4.5-1.el5_5.1.ppc.rpm
• postgresql-7.4.30-1.el4_8.1.x86_64.rpm
• postgresql-8.1.22-1.el5_5.1.s390x.rpm
• postgresql-python-7.4.30-1.el4_8.1.s390x.rpm
• postgresql84-docs-8.4.5-1.el5_5.1.x86_64.rpm
• postgresql84-devel-8.4.5-1.el5_5.1.ppc.rpm
• postgresql-contrib-8.1.22-1.el5_5.1.s390x.rpm
• postgresql-libs-7.4.30-1.el4_8.1.i386.rpm
• postgresql-tcl-7.4.30-1.el4_8.1.s390.rpm
• postgresql84-server-8.4.5-1.el5_5.1.s390x.rpm
• postgresql-server-8.1.22-1.el5_5.1.s390x.rpm
• postgresql-devel-8.1.22-1.el5_5.1.i386.rpm
• postgresql84-test-8.4.5-1.el5_5.1.x86_64.rpm
• postgresql-server-8.1.22-1.el5_5.1.i386.rpm
• postgresql-test-8.1.22-1.el5_5.1.s390x.rpm
• postgresql-devel-8.1.22-1.el5_5.1.s390.rpm
• postgresql84-libs-8.4.5-1.el5_5.1.x86_64.rpm
• postgresql-server-8.1.22-1.el5_5.1.ppc.rpm
• postgresql-pl-8.1.22-1.el5_5.1.x86_64.rpm
• postgresql-test-8.1.22-1.el5_5.1.ia64.rpm
• postgresql84-plperl-8.4.5-1.el5_5.1.ia64.rpm
• postgresql84-python-8.4.5-1.el5_5.1.ppc.rpm
• postgresql-libs-7.4.30-1.el4_8.1.x86_64.rpm
• postgresql84-contrib-8.4.5-1.el5_5.1.ppc.rpm
• postgresql-server-7.4.30-1.el4_8.1.s390.rpm
• postgresql84-libs-8.4.5-1.el5_5.1.s390x.rpm
• postgresql84-pltcl-8.4.5-1.el5_5.1.ia64.rpm
• postgresql-libs-8.1.22-1.el5_5.1.ppc64.rpm
• postgresql-docs-8.1.22-1.el5_5.1.i386.rpm
• postgresql84-python-8.4.5-1.el5_5.1.i386.rpm
• postgresql-pl-7.4.30-1.el4_8.1.i386.rpm
• postgresql-server-7.4.30-1.el4_8.1.ppc.rpm
• postgresql-server-7.4.30-1.el4_8.1.s390x.rpm
• postgresql-8.1.22-1.el5_5.1.src.rpm
• postgresql-contrib-8.1.22-1.el5_5.1.ppc.rpm
• postgresql-test-7.4.30-1.el4_8.1.s390.rpm
• postgresql-devel-7.4.30-1.el4_8.1.s390x.rpm
• postgresql-tcl-7.4.30-1.el4_8.1.ia64.rpm
• postgresql-7.4.30-1.el4_8.1.i386.rpm
• postgresql-7.4.30-1.el4_8.1.ia64.rpm
• postgresql-devel-7.4.30-1.el4_8.1.x86_64.rpm
• postgresql-jdbc-7.4.30-1.el4_8.1.i386.rpm
• postgresql-pl-7.4.30-1.el4_8.1.x86_64.rpm
• postgresql-tcl-7.4.30-1.el4_8.1.s390x.rpm
• postgresql84-devel-8.4.5-1.el5_5.1.s390.rpm
• postgresql-pl-7.4.30-1.el4_8.1.s390.rpm
• postgresql-devel-8.1.22-1.el5_5.1.x86_64.rpm
• postgresql-python-7.4.30-1.el4_8.1.ia64.rpm
• postgresql84-contrib-8.4.5-1.el5_5.1.ia64.rpm
• postgresql84-contrib-8.4.5-1.el5_5.1.s390x.rpm
• postgresql-jdbc-7.4.30-1.el4_8.1.x86_64.rpm
• postgresql-devel-7.4.30-1.el4_8.1.s390.rpm
• postgresql-docs-7.4.30-1.el4_8.1.s390.rpm
• postgresql-tcl-8.1.22-1.el5_5.1.x86_64.rpm
• postgresql-pl-8.1.22-1.el5_5.1.ppc.rpm
• postgresql84-docs-8.4.5-1.el5_5.1.ia64.rpm
• postgresql-docs-7.4.30-1.el4_8.1.x86_64.rpm
• postgresql-jdbc-7.4.30-1.el4_8.1.ia64.rpm
• postgresql-docs-8.1.22-1.el5_5.1.ia64.rpm
• postgresql-test-7.4.30-1.el4_8.1.ia64.rpm
• postgresql-jdbc-7.4.30-1.el4_8.1.ppc.rpm
• postgresql-server-7.4.30-1.el4_8.1.i386.rpm
• postgresql-contrib-8.1.22-1.el5_5.1.x86_64.rpm
• postgresql-tcl-8.1.22-1.el5_5.1.i386.rpm
• postgresql84-8.4.5-1.el5_5.1.src.rpm
• postgresql-test-7.4.30-1.el4_8.1.x86_64.rpm
• postgresql-pl-7.4.30-1.el4_8.1.s390x.rpm
• postgresql84-8.4.5-1.el5_5.1.i386.rpm
• postgresql84-libs-8.4.5-1.el5_5.1.s390.rpm
• postgresql-contrib-7.4.30-1.el4_8.1.ppc.rpm
• postgresql84-tcl-8.4.5-1.el5_5.1.s390x.rpm
• postgresql-test-8.1.22-1.el5_5.1.i386.rpm
• postgresql-libs-8.1.22-1.el5_5.1.x86_64.rpm
• postgresql-tcl-8.1.22-1.el5_5.1.s390x.rpm
• postgresql84-plpython-8.4.5-1.el5_5.1.x86_64.rpm
• postgresql84-plpython-8.4.5-1.el5_5.1.ppc.rpm
• postgresql-libs-7.4.30-1.el4_8.1.ia64.rpm
• postgresql84-server-8.4.5-1.el5_5.1.ia64.rpm
• postgresql-libs-8.1.22-1.el5_5.1.s390.rpm
• postgresql-libs-8.1.22-1.el5_5.1.s390x.rpm
• postgresql-pl-8.1.22-1.el5_5.1.s390x.rpm
• postgresql84-pltcl-8.4.5-1.el5_5.1.i386.rpm
• postgresql84-docs-8.4.5-1.el5_5.1.i386.rpm
• postgresql-contrib-7.4.30-1.el4_8.1.i386.rpm
• postgresql84-8.4.5-1.el5_5.1.ppc64.rpm
• postgresql84-libs-8.4.5-1.el5_5.1.ia64.rpm
• postgresql-7.4.30-1.el4_8.1.ppc.rpm
• postgresql-contrib-7.4.30-1.el4_8.1.ia64.rpm
• postgresql-devel-8.1.22-1.el5_5.1.s390x.rpm
• postgresql84-libs-8.4.5-1.el5_5.1.ppc64.rpm
• postgresql-libs-7.4.30-1.el4_8.1.ppc64.rpm
• postgresql-pl-7.4.30-1.el4_8.1.ppc.rpm
• postgresql-8.1.22-1.el5_5.1.i386.rpm
• postgresql-docs-7.4.30-1.el4_8.1.i386.rpm
• postgresql-8.1.22-1.el5_5.1.x86_64.rpm
• postgresql-tcl-7.4.30-1.el4_8.1.ppc.rpm
• postgresql84-8.4.5-1.el5_5.1.ia64.rpm
• postgresql84-python-8.4.5-1.el5_5.1.s390x.rpm
• postgresql-test-7.4.30-1.el4_8.1.s390x.rpm
• postgresql-pl-8.1.22-1.el5_5.1.i386.rpm
• postgresql-python-7.4.30-1.el4_8.1.ppc.rpm

Fixes

• This content is not included.BZ - 639371

CVEs

• CVE-2010-3433

References

• http://www.redhat.com/security/updates/classification/#moderate
• Content from www.postgresql.org is not included.Content from www.postgresql.org is not included.http://www.postgresql.org/docs/8.1/interactive/sql-createfunction.html

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.