Articles / Red Hat: Updated postgresql…

Red Hat: Updated postgresql packages fix multiple security issues

PostgreSQL is an advanced object-relational database management system (DBMS). A flaw was found in the way PostgreSQL enforced permission checks on scripts written in PL/Perl or PL/Tcl, which could allow an attacker to bypass intended PL/Perl trusted mode restrictions, allowing them to run arbitrary scripts with the privileges of the database server. A buffer overflow flaw was found in the way PostgreSQL retrieved a substring from the bit string for BIT() and BIT VARYING() SQL data types, leading to a temporary denial of service. An integer overflow flaw was found in the way PostgreSQL used to calculate the size of the hash table for joined relations, which could cause a temporary denial of service. PostgreSQL improperly protected session-local state during the execution of an index function by a database superuser during the database maintenance operations, leading to elevated privileges. Updated packages are available from updates.redhat.com.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

=====================================================================
                  Red Hat Security Advisory

Synopsis:          Moderate: postgresql security update
Advisory ID:       RHSA-2010:0427-01
Product:           Red Hat Enterprise Linux
Advisory URL:      https://rhn.redhat.com/errata/RHSA-2010-0427.html
Issue date:        2010-05-19
CVE Names:         CVE-2009-4136 CVE-2010-0442 CVE-2010-0733 
                  CVE-2010-1169 CVE-2010-1170 
=====================================================================

1. Summary:

Updated postgresql packages that fix multiple security issues are now
available for Red Hat Enterprise Linux 3.

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.

2. Relevant releases/architectures:

Red Hat Desktop version 3 - i386, x86_64
Red Hat Enterprise Linux AS version 3 - i386, ia64, ppc, s390, s390x, x86_64
Red Hat Enterprise Linux ES version 3 - i386, ia64, x86_64
Red Hat Enterprise Linux WS version 3 - i386, ia64, x86_64

3. 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, and are installed in trusted mode by default. In
trusted mode, certain operations, such as operating system level access,
are restricted.

A flaw was found in the way PostgreSQL enforced permission checks on
scripts written in PL/Perl. If the PL/Perl procedural language was
registered on a particular database, an authenticated database user running
a specially-crafted PL/Perl script could use this flaw to bypass intended
PL/Perl trusted mode restrictions, allowing them to run arbitrary Perl
scripts with the privileges of the database server. (CVE-2010-1169)

Red Hat would like to thank Tim Bunce for responsibly reporting the
CVE-2010-1169 flaw.

A flaw was found in the way PostgreSQL enforced permission checks on
scripts written in PL/Tcl. If the PL/Tcl procedural language was registered
on a particular database, an authenticated database user running a
specially-crafted PL/Tcl script could use this flaw to bypass intended
PL/Tcl trusted mode restrictions, allowing them to run arbitrary Tcl
scripts with the privileges of the database server. (CVE-2010-1170)

A buffer overflow flaw was found in the way PostgreSQL retrieved a
substring from the bit string for BIT() and BIT VARYING() SQL data types.
An authenticated database user running a specially-crafted SQL query could
use this flaw to cause a temporary denial of service (postgres daemon
crash) or, potentially, execute arbitrary code with the privileges of the
database server. (CVE-2010-0442)

An integer overflow flaw was found in the way PostgreSQL used to calculate
the size of the hash table for joined relations. An authenticated database
user could create a specially-crafted SQL query which could cause a
temporary denial of service (postgres daemon crash) or, potentially,
execute arbitrary code with the privileges of the database server.
(CVE-2010-0733)

PostgreSQL improperly protected session-local state during the execution of
an index function by a database superuser during the database maintenance
operations. An authenticated database user could use this flaw to elevate
their privileges via specially-crafted index functions. (CVE-2009-4136)

All PostgreSQL users are advised to upgrade to these updated packages,
which contain backported patches to correct these issues. Running
PostgreSQL instances must be restarted ("service rhdb restart") for this
update to take effect.

4. 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
http://kbase.redhat.com/faq/docs/DOC-11259

5. Bugs fixed (http://bugzilla.redhat.com/):

546321 - CVE-2009-4136 postgresql: SQL privilege escalation via modifications to session-local state
546621 - CVE-2010-0733 postgresql: Integer overflow in hash table size calculation
559259 - CVE-2010-0442 postgresql: substring() negative length argument buffer overflow
582615 - CVE-2010-1169 PostgreSQL: PL/Perl Intended restriction bypass
583072 - CVE-2010-1170 PostgreSQL: PL/Tcl Intended restriction bypass

6. Package List:

Red Hat Enterprise Linux AS version 3:

Source:
ftp://updates.redhat.com/enterprise/3AS/en/os/SRPMS/rh-postgresql-7.3.21-3.src.rpm

i386:
rh-postgresql-7.3.21-3.i386.rpm
rh-postgresql-contrib-7.3.21-3.i386.rpm
rh-postgresql-debuginfo-7.3.21-3.i386.rpm
rh-postgresql-devel-7.3.21-3.i386.rpm
rh-postgresql-docs-7.3.21-3.i386.rpm
rh-postgresql-jdbc-7.3.21-3.i386.rpm
rh-postgresql-libs-7.3.21-3.i386.rpm
rh-postgresql-pl-7.3.21-3.i386.rpm
rh-postgresql-python-7.3.21-3.i386.rpm
rh-postgresql-server-7.3.21-3.i386.rpm
rh-postgresql-tcl-7.3.21-3.i386.rpm
rh-postgresql-test-7.3.21-3.i386.rpm

ia64:
rh-postgresql-7.3.21-3.ia64.rpm
rh-postgresql-contrib-7.3.21-3.ia64.rpm
rh-postgresql-debuginfo-7.3.21-3.i386.rpm
rh-postgresql-debuginfo-7.3.21-3.ia64.rpm
rh-postgresql-devel-7.3.21-3.ia64.rpm
rh-postgresql-docs-7.3.21-3.ia64.rpm
rh-postgresql-jdbc-7.3.21-3.ia64.rpm
rh-postgresql-libs-7.3.21-3.i386.rpm
rh-postgresql-libs-7.3.21-3.ia64.rpm
rh-postgresql-pl-7.3.21-3.ia64.rpm
rh-postgresql-python-7.3.21-3.ia64.rpm
rh-postgresql-server-7.3.21-3.ia64.rpm
rh-postgresql-tcl-7.3.21-3.ia64.rpm
rh-postgresql-test-7.3.21-3.ia64.rpm

ppc:
rh-postgresql-7.3.21-3.ppc.rpm
rh-postgresql-contrib-7.3.21-3.ppc.rpm
rh-postgresql-debuginfo-7.3.21-3.ppc.rpm
rh-postgresql-debuginfo-7.3.21-3.ppc64.rpm
rh-postgresql-devel-7.3.21-3.ppc.rpm
rh-postgresql-docs-7.3.21-3.ppc.rpm
rh-postgresql-jdbc-7.3.21-3.ppc.rpm
rh-postgresql-libs-7.3.21-3.ppc.rpm
rh-postgresql-libs-7.3.21-3.ppc64.rpm
rh-postgresql-pl-7.3.21-3.ppc.rpm
rh-postgresql-python-7.3.21-3.ppc.rpm
rh-postgresql-server-7.3.21-3.ppc.rpm
rh-postgresql-tcl-7.3.21-3.ppc.rpm
rh-postgresql-test-7.3.21-3.ppc.rpm

s390:
rh-postgresql-7.3.21-3.s390.rpm
rh-postgresql-contrib-7.3.21-3.s390.rpm
rh-postgresql-debuginfo-7.3.21-3.s390.rpm
rh-postgresql-devel-7.3.21-3.s390.rpm
rh-postgresql-docs-7.3.21-3.s390.rpm
rh-postgresql-jdbc-7.3.21-3.s390.rpm
rh-postgresql-libs-7.3.21-3.s390.rpm
rh-postgresql-pl-7.3.21-3.s390.rpm
rh-postgresql-python-7.3.21-3.s390.rpm
rh-postgresql-server-7.3.21-3.s390.rpm
rh-postgresql-tcl-7.3.21-3.s390.rpm
rh-postgresql-test-7.3.21-3.s390.rpm

s390x:
rh-postgresql-7.3.21-3.s390x.rpm
rh-postgresql-contrib-7.3.21-3.s390x.rpm
rh-postgresql-debuginfo-7.3.21-3.s390.rpm
rh-postgresql-debuginfo-7.3.21-3.s390x.rpm
rh-postgresql-devel-7.3.21-3.s390x.rpm
rh-postgresql-docs-7.3.21-3.s390x.rpm
rh-postgresql-jdbc-7.3.21-3.s390x.rpm
rh-postgresql-libs-7.3.21-3.s390.rpm
rh-postgresql-libs-7.3.21-3.s390x.rpm
rh-postgresql-pl-7.3.21-3.s390x.rpm
rh-postgresql-python-7.3.21-3.s390x.rpm
rh-postgresql-server-7.3.21-3.s390x.rpm
rh-postgresql-tcl-7.3.21-3.s390x.rpm
rh-postgresql-test-7.3.21-3.s390x.rpm

x86_64:
rh-postgresql-7.3.21-3.x86_64.rpm
rh-postgresql-contrib-7.3.21-3.x86_64.rpm
rh-postgresql-debuginfo-7.3.21-3.i386.rpm
rh-postgresql-debuginfo-7.3.21-3.x86_64.rpm
rh-postgresql-devel-7.3.21-3.x86_64.rpm
rh-postgresql-docs-7.3.21-3.x86_64.rpm
rh-postgresql-jdbc-7.3.21-3.x86_64.rpm
rh-postgresql-libs-7.3.21-3.i386.rpm
rh-postgresql-libs-7.3.21-3.x86_64.rpm
rh-postgresql-pl-7.3.21-3.x86_64.rpm
rh-postgresql-python-7.3.21-3.x86_64.rpm
rh-postgresql-server-7.3.21-3.x86_64.rpm
rh-postgresql-tcl-7.3.21-3.x86_64.rpm
rh-postgresql-test-7.3.21-3.x86_64.rpm

Red Hat Desktop version 3:

Source:
ftp://updates.redhat.com/enterprise/3desktop/en/os/SRPMS/rh-postgresql-7.3.21-3.src.rpm

i386:
rh-postgresql-7.3.21-3.i386.rpm
rh-postgresql-contrib-7.3.21-3.i386.rpm
rh-postgresql-debuginfo-7.3.21-3.i386.rpm
rh-postgresql-devel-7.3.21-3.i386.rpm
rh-postgresql-docs-7.3.21-3.i386.rpm
rh-postgresql-jdbc-7.3.21-3.i386.rpm
rh-postgresql-libs-7.3.21-3.i386.rpm
rh-postgresql-pl-7.3.21-3.i386.rpm
rh-postgresql-python-7.3.21-3.i386.rpm
rh-postgresql-server-7.3.21-3.i386.rpm
rh-postgresql-tcl-7.3.21-3.i386.rpm
rh-postgresql-test-7.3.21-3.i386.rpm

x86_64:
rh-postgresql-7.3.21-3.x86_64.rpm
rh-postgresql-contrib-7.3.21-3.x86_64.rpm
rh-postgresql-debuginfo-7.3.21-3.i386.rpm
rh-postgresql-debuginfo-7.3.21-3.x86_64.rpm
rh-postgresql-devel-7.3.21-3.x86_64.rpm
rh-postgresql-docs-7.3.21-3.x86_64.rpm
rh-postgresql-jdbc-7.3.21-3.x86_64.rpm
rh-postgresql-libs-7.3.21-3.i386.rpm
rh-postgresql-libs-7.3.21-3.x86_64.rpm
rh-postgresql-pl-7.3.21-3.x86_64.rpm
rh-postgresql-python-7.3.21-3.x86_64.rpm
rh-postgresql-server-7.3.21-3.x86_64.rpm
rh-postgresql-tcl-7.3.21-3.x86_64.rpm
rh-postgresql-test-7.3.21-3.x86_64.rpm

Red Hat Enterprise Linux ES version 3:

Source:
ftp://updates.redhat.com/enterprise/3ES/en/os/SRPMS/rh-postgresql-7.3.21-3.src.rpm

i386:
rh-postgresql-7.3.21-3.i386.rpm
rh-postgresql-contrib-7.3.21-3.i386.rpm
rh-postgresql-debuginfo-7.3.21-3.i386.rpm
rh-postgresql-devel-7.3.21-3.i386.rpm
rh-postgresql-docs-7.3.21-3.i386.rpm
rh-postgresql-jdbc-7.3.21-3.i386.rpm
rh-postgresql-libs-7.3.21-3.i386.rpm
rh-postgresql-pl-7.3.21-3.i386.rpm
rh-postgresql-python-7.3.21-3.i386.rpm
rh-postgresql-server-7.3.21-3.i386.rpm
rh-postgresql-tcl-7.3.21-3.i386.rpm
rh-postgresql-test-7.3.21-3.i386.rpm

ia64:
rh-postgresql-7.3.21-3.ia64.rpm
rh-postgresql-contrib-7.3.21-3.ia64.rpm
rh-postgresql-debuginfo-7.3.21-3.i386.rpm
rh-postgresql-debuginfo-7.3.21-3.ia64.rpm
rh-postgresql-devel-7.3.21-3.ia64.rpm
rh-postgresql-docs-7.3.21-3.ia64.rpm
rh-postgresql-jdbc-7.3.21-3.ia64.rpm
rh-postgresql-libs-7.3.21-3.i386.rpm
rh-postgresql-libs-7.3.21-3.ia64.rpm
rh-postgresql-pl-7.3.21-3.ia64.rpm
rh-postgresql-python-7.3.21-3.ia64.rpm
rh-postgresql-server-7.3.21-3.ia64.rpm
rh-postgresql-tcl-7.3.21-3.ia64.rpm
rh-postgresql-test-7.3.21-3.ia64.rpm

x86_64:
rh-postgresql-7.3.21-3.x86_64.rpm
rh-postgresql-contrib-7.3.21-3.x86_64.rpm
rh-postgresql-debuginfo-7.3.21-3.i386.rpm
rh-postgresql-debuginfo-7.3.21-3.x86_64.rpm
rh-postgresql-devel-7.3.21-3.x86_64.rpm
rh-postgresql-docs-7.3.21-3.x86_64.rpm
rh-postgresql-jdbc-7.3.21-3.x86_64.rpm
rh-postgresql-libs-7.3.21-3.i386.rpm
rh-postgresql-libs-7.3.21-3.x86_64.rpm
rh-postgresql-pl-7.3.21-3.x86_64.rpm
rh-postgresql-python-7.3.21-3.x86_64.rpm
rh-postgresql-server-7.3.21-3.x86_64.rpm
rh-postgresql-tcl-7.3.21-3.x86_64.rpm
rh-postgresql-test-7.3.21-3.x86_64.rpm

Red Hat Enterprise Linux WS version 3:

Source:
ftp://updates.redhat.com/enterprise/3WS/en/os/SRPMS/rh-postgresql-7.3.21-3.src.rpm

i386:
rh-postgresql-7.3.21-3.i386.rpm
rh-postgresql-contrib-7.3.21-3.i386.rpm
rh-postgresql-debuginfo-7.3.21-3.i386.rpm
rh-postgresql-devel-7.3.21-3.i386.rpm
rh-postgresql-docs-7.3.21-3.i386.rpm
rh-postgresql-jdbc-7.3.21-3.i386.rpm
rh-postgresql-libs-7.3.21-3.i386.rpm
rh-postgresql-pl-7.3.21-3.i386.rpm
rh-postgresql-python-7.3.21-3.i386.rpm
rh-postgresql-server-7.3.21-3.i386.rpm
rh-postgresql-tcl-7.3.21-3.i386.rpm
rh-postgresql-test-7.3.21-3.i386.rpm

ia64:
rh-postgresql-7.3.21-3.ia64.rpm
rh-postgresql-contrib-7.3.21-3.ia64.rpm
rh-postgresql-debuginfo-7.3.21-3.i386.rpm
rh-postgresql-debuginfo-7.3.21-3.ia64.rpm
rh-postgresql-devel-7.3.21-3.ia64.rpm
rh-postgresql-docs-7.3.21-3.ia64.rpm
rh-postgresql-jdbc-7.3.21-3.ia64.rpm
rh-postgresql-libs-7.3.21-3.i386.rpm
rh-postgresql-libs-7.3.21-3.ia64.rpm
rh-postgresql-pl-7.3.21-3.ia64.rpm
rh-postgresql-python-7.3.21-3.ia64.rpm
rh-postgresql-server-7.3.21-3.ia64.rpm
rh-postgresql-tcl-7.3.21-3.ia64.rpm
rh-postgresql-test-7.3.21-3.ia64.rpm

x86_64:
rh-postgresql-7.3.21-3.x86_64.rpm
rh-postgresql-contrib-7.3.21-3.x86_64.rpm
rh-postgresql-debuginfo-7.3.21-3.i386.rpm
rh-postgresql-debuginfo-7.3.21-3.x86_64.rpm
rh-postgresql-devel-7.3.21-3.x86_64.rpm
rh-postgresql-docs-7.3.21-3.x86_64.rpm
rh-postgresql-jdbc-7.3.21-3.x86_64.rpm
rh-postgresql-libs-7.3.21-3.i386.rpm
rh-postgresql-libs-7.3.21-3.x86_64.rpm
rh-postgresql-pl-7.3.21-3.x86_64.rpm
rh-postgresql-python-7.3.21-3.x86_64.rpm
rh-postgresql-server-7.3.21-3.x86_64.rpm
rh-postgresql-tcl-7.3.21-3.x86_64.rpm
rh-postgresql-test-7.3.21-3.x86_64.rpm

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

7. References:

https://www.redhat.com/security/data/cve/CVE-2009-4136.html
https://www.redhat.com/security/data/cve/CVE-2010-0442.html
https://www.redhat.com/security/data/cve/CVE-2010-0733.html
https://www.redhat.com/security/data/cve/CVE-2010-1169.html
https://www.redhat.com/security/data/cve/CVE-2010-1170.html
http://www.redhat.com/security/updates/classification/#moderate

8. Contact:

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

Copyright 2010 Red Hat, Inc.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.4 (GNU/Linux)

iD8DBQFL9BmSXlSAg2UNWIIRApYpAJ4pVbgOZCF3JfwnusgzotUQrSqshQCfWvH+
iueusYINpQ2fIejHu6GXFrQ=
=Ecx2
-----END PGP SIGNATURE-----
Screenshot

Project Spotlight

Kigo Video Converter Ultimate for Mac

A tool for converting and editing videos.

Screenshot

Project Spotlight

Kid3

An efficient tagger for MP3, Ogg/Vorbis, and FLAC files.