Moderate: postgresql security update

Advisory:	RHSA-2009:1485-1
Type:	Security Advisory
Severity:	Moderate
Issued on:	2009-10-07
Last updated on:	2009-10-07
Affected Products:	Red Hat Desktop (v. 3) Red Hat Enterprise Linux AS (v. 3) Red Hat Enterprise Linux ES (v. 3) Red Hat Enterprise Linux WS (v. 3)
OVAL:	com.redhat.rhsa-20091485.xml
CVEs (cve.mitre.org):	CVE-2009-3230

Details

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

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

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:0039 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)

All PostgreSQL users should upgrade to these updated packages, which
contain a backported patch to correct this issue. If you are running a
PostgreSQL server, the postgresql service must be restarted for this update
to take effect.

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

Updated packages

Red Hat Desktop (v. 3)

SRPMS:
rh-postgresql-7.3.21-2.src.rpm	`dc3bbd2ec9f5787a82766cb90046a03f`

IA-32:
rh-postgresql-7.3.21-2.i386.rpm	`0cd688f9eaea20bfd701e73fb2dfb924`
rh-postgresql-contrib-7.3.21-2.i386.rpm	`c31b5321b0b41480564321d7fd98abc2`
rh-postgresql-devel-7.3.21-2.i386.rpm	`68733f637388d81ef68c411ed70b43b7`
rh-postgresql-docs-7.3.21-2.i386.rpm	`82d61d4ffb715cc2a409dcec5a8eaa2e`
rh-postgresql-jdbc-7.3.21-2.i386.rpm	`e7984167bb4cbce7028ec586494177a5`
rh-postgresql-libs-7.3.21-2.i386.rpm	`46d7c730734cbb317b1acc701e372a06`
rh-postgresql-pl-7.3.21-2.i386.rpm	`60d750aeecbe18dfa9699a46ae95d2ac`
rh-postgresql-python-7.3.21-2.i386.rpm	`f6f76927348581d90dee592d76ac73b7`
rh-postgresql-server-7.3.21-2.i386.rpm	`098ea5ed779cbdcc10dce20906270e24`
rh-postgresql-tcl-7.3.21-2.i386.rpm	`ae5b965acf8b4bcbce45d50ce79fb6c5`
rh-postgresql-test-7.3.21-2.i386.rpm	`4c3d9dddaa6c0a36c65375f35c2680c8`

x86_64:
rh-postgresql-7.3.21-2.x86_64.rpm	`8d9ab0a506886c0870af249d5df3e4be`
rh-postgresql-contrib-7.3.21-2.x86_64.rpm	`3f946cba9fcc23e83fa056bef36235d7`
rh-postgresql-devel-7.3.21-2.x86_64.rpm	`bf421cfd0eec0fe3048faaebe3a341e8`
rh-postgresql-docs-7.3.21-2.x86_64.rpm	`6e9342b17cfc09a7399d371b31d57b8f`
rh-postgresql-jdbc-7.3.21-2.x86_64.rpm	`b51b2413b347653342fccd2a878d516f`
rh-postgresql-libs-7.3.21-2.i386.rpm	`46d7c730734cbb317b1acc701e372a06`
rh-postgresql-libs-7.3.21-2.x86_64.rpm	`200c39262d844b43c17d7fd95947a57a`
rh-postgresql-pl-7.3.21-2.x86_64.rpm	`b20c1951ef6fedee01f5df4c8ce8e2b8`
rh-postgresql-python-7.3.21-2.x86_64.rpm	`6df12da5d2d878cfde318d059c33b037`
rh-postgresql-server-7.3.21-2.x86_64.rpm	`807b2dea6c5d5df51dd77ee866ded8db`
rh-postgresql-tcl-7.3.21-2.x86_64.rpm	`4eb3503690445593d789c70651a085a1`
rh-postgresql-test-7.3.21-2.x86_64.rpm	`f587c9460f8f614bb51d167cb31916bd`

Red Hat Enterprise Linux AS (v. 3)

SRPMS:
rh-postgresql-7.3.21-2.src.rpm	`dc3bbd2ec9f5787a82766cb90046a03f`

IA-32:
rh-postgresql-7.3.21-2.i386.rpm	`0cd688f9eaea20bfd701e73fb2dfb924`
rh-postgresql-contrib-7.3.21-2.i386.rpm	`c31b5321b0b41480564321d7fd98abc2`
rh-postgresql-devel-7.3.21-2.i386.rpm	`68733f637388d81ef68c411ed70b43b7`
rh-postgresql-docs-7.3.21-2.i386.rpm	`82d61d4ffb715cc2a409dcec5a8eaa2e`
rh-postgresql-jdbc-7.3.21-2.i386.rpm	`e7984167bb4cbce7028ec586494177a5`
rh-postgresql-libs-7.3.21-2.i386.rpm	`46d7c730734cbb317b1acc701e372a06`
rh-postgresql-pl-7.3.21-2.i386.rpm	`60d750aeecbe18dfa9699a46ae95d2ac`
rh-postgresql-python-7.3.21-2.i386.rpm	`f6f76927348581d90dee592d76ac73b7`
rh-postgresql-server-7.3.21-2.i386.rpm	`098ea5ed779cbdcc10dce20906270e24`
rh-postgresql-tcl-7.3.21-2.i386.rpm	`ae5b965acf8b4bcbce45d50ce79fb6c5`
rh-postgresql-test-7.3.21-2.i386.rpm	`4c3d9dddaa6c0a36c65375f35c2680c8`

IA-64:
rh-postgresql-7.3.21-2.ia64.rpm	`f1ec42961731d07c049d818e7eb8c04a`
rh-postgresql-contrib-7.3.21-2.ia64.rpm	`beb3fabcab7da2b1ff3852be471879e7`
rh-postgresql-devel-7.3.21-2.ia64.rpm	`1126c8543de0b36bfc290633044da56b`
rh-postgresql-docs-7.3.21-2.ia64.rpm	`0f87fdb2088d5f440ae786e29e2db13a`
rh-postgresql-jdbc-7.3.21-2.ia64.rpm	`0d28e91d6676c9a247eed8cdc24cf75a`
rh-postgresql-libs-7.3.21-2.i386.rpm	`46d7c730734cbb317b1acc701e372a06`
rh-postgresql-libs-7.3.21-2.ia64.rpm	`399ca38a0f28ab4484e90bbb5b5e4946`
rh-postgresql-pl-7.3.21-2.ia64.rpm	`9f6d3ee1e1eeea4c1516dee93c6de02a`
rh-postgresql-python-7.3.21-2.ia64.rpm	`607cf2e04a1f8679bbdecaf170d9956f`
rh-postgresql-server-7.3.21-2.ia64.rpm	`549891f26c4335f4574c48210f2b9453`
rh-postgresql-tcl-7.3.21-2.ia64.rpm	`6938ac2665ef734987e5cd3f27375332`
rh-postgresql-test-7.3.21-2.ia64.rpm	`f2120b8093b2a62fd9cf9419725308ac`

PPC:
rh-postgresql-7.3.21-2.ppc.rpm	`4f8d9865b5e5dc9044c7d2f3e4348d83`
rh-postgresql-contrib-7.3.21-2.ppc.rpm	`ecb034e4b2d1292d61af6232784fc46f`
rh-postgresql-devel-7.3.21-2.ppc.rpm	`d999c47d512f2001f6c5f45b7f3763d4`
rh-postgresql-docs-7.3.21-2.ppc.rpm	`47af62a8e8405f49681c86deb048a248`
rh-postgresql-jdbc-7.3.21-2.ppc.rpm	`65c1cf6941b062dcf0dbf71e5ba42839`
rh-postgresql-libs-7.3.21-2.ppc.rpm	`bbe582598fbc52322f15c2157461128d`
rh-postgresql-libs-7.3.21-2.ppc64.rpm	`e8cdacd6b60929cdc83cb945e7b0852b`
rh-postgresql-pl-7.3.21-2.ppc.rpm	`62926c066d2d79bbcc578c9bd5a5ff28`
rh-postgresql-python-7.3.21-2.ppc.rpm	`538dcdbb175780f2ec5cd0211e723049`
rh-postgresql-server-7.3.21-2.ppc.rpm	`ed7c26637a851d320332ff90fc103062`
rh-postgresql-tcl-7.3.21-2.ppc.rpm	`e2e039175ed13b408be59c8a1e5857bf`
rh-postgresql-test-7.3.21-2.ppc.rpm	`0fa5a549101053e7de7d9e3a54fb20b0`

s390:
rh-postgresql-7.3.21-2.s390.rpm	`02a952dce161bc0984e67e9e965ca357`
rh-postgresql-contrib-7.3.21-2.s390.rpm	`9688d826a1f4c11799b5c8c64fa9232f`
rh-postgresql-devel-7.3.21-2.s390.rpm	`97b71b9b005efe4d519de38bd46b9e6c`
rh-postgresql-docs-7.3.21-2.s390.rpm	`db1285cd759096196273a573c709fff5`
rh-postgresql-jdbc-7.3.21-2.s390.rpm	`24d51928bb75f4f644ef49e5bb21795d`
rh-postgresql-libs-7.3.21-2.s390.rpm	`0720aeed003262d4a0fcf12408eea41e`
rh-postgresql-pl-7.3.21-2.s390.rpm	`08822b0f0cbb0d64b37a4e4205ad032e`
rh-postgresql-python-7.3.21-2.s390.rpm	`1fc35699c8e6920987429a498111df4e`
rh-postgresql-server-7.3.21-2.s390.rpm	`7dd2ee841d1b71e754321442de4f8ea2`
rh-postgresql-tcl-7.3.21-2.s390.rpm	`3f9bf1bf9f70dd7f809771195eb59e5c`
rh-postgresql-test-7.3.21-2.s390.rpm	`d81b7c40bc2420a861a4d297b056eab1`

s390x:
rh-postgresql-7.3.21-2.s390x.rpm	`ade3864d48f6e537e14911e19effd367`
rh-postgresql-contrib-7.3.21-2.s390x.rpm	`207674e075beff39e7db9ef8b4735d4c`
rh-postgresql-devel-7.3.21-2.s390x.rpm	`5adb2d747d272f895d53683412e092ec`
rh-postgresql-docs-7.3.21-2.s390x.rpm	`a69e570fcca7181214541e7804ba0bbf`
rh-postgresql-jdbc-7.3.21-2.s390x.rpm	`11c7cd6c245b373cdc4c2c16b93b18ec`
rh-postgresql-libs-7.3.21-2.s390.rpm	`0720aeed003262d4a0fcf12408eea41e`
rh-postgresql-libs-7.3.21-2.s390x.rpm	`166bbc3978339c1403849eee484d589b`
rh-postgresql-pl-7.3.21-2.s390x.rpm	`b96b574ed9d206aa1075aeedcc52f74b`
rh-postgresql-python-7.3.21-2.s390x.rpm	`a2a69a10bba164ba56de7a9178c1d47d`
rh-postgresql-server-7.3.21-2.s390x.rpm	`466f2b7ae7e85ce9838005a1d2fb085d`
rh-postgresql-tcl-7.3.21-2.s390x.rpm	`10eb69951cb0d3545511c9a9190b43bd`
rh-postgresql-test-7.3.21-2.s390x.rpm	`63c81579b3c2489c86c9088b9b9bfb70`

x86_64:
rh-postgresql-7.3.21-2.x86_64.rpm	`8d9ab0a506886c0870af249d5df3e4be`
rh-postgresql-contrib-7.3.21-2.x86_64.rpm	`3f946cba9fcc23e83fa056bef36235d7`
rh-postgresql-devel-7.3.21-2.x86_64.rpm	`bf421cfd0eec0fe3048faaebe3a341e8`
rh-postgresql-docs-7.3.21-2.x86_64.rpm	`6e9342b17cfc09a7399d371b31d57b8f`
rh-postgresql-jdbc-7.3.21-2.x86_64.rpm	`b51b2413b347653342fccd2a878d516f`
rh-postgresql-libs-7.3.21-2.i386.rpm	`46d7c730734cbb317b1acc701e372a06`
rh-postgresql-libs-7.3.21-2.x86_64.rpm	`200c39262d844b43c17d7fd95947a57a`
rh-postgresql-pl-7.3.21-2.x86_64.rpm	`b20c1951ef6fedee01f5df4c8ce8e2b8`
rh-postgresql-python-7.3.21-2.x86_64.rpm	`6df12da5d2d878cfde318d059c33b037`
rh-postgresql-server-7.3.21-2.x86_64.rpm	`807b2dea6c5d5df51dd77ee866ded8db`
rh-postgresql-tcl-7.3.21-2.x86_64.rpm	`4eb3503690445593d789c70651a085a1`
rh-postgresql-test-7.3.21-2.x86_64.rpm	`f587c9460f8f614bb51d167cb31916bd`

Red Hat Enterprise Linux ES (v. 3)

SRPMS:
rh-postgresql-7.3.21-2.src.rpm	`dc3bbd2ec9f5787a82766cb90046a03f`

IA-32:
rh-postgresql-7.3.21-2.i386.rpm	`0cd688f9eaea20bfd701e73fb2dfb924`
rh-postgresql-contrib-7.3.21-2.i386.rpm	`c31b5321b0b41480564321d7fd98abc2`
rh-postgresql-devel-7.3.21-2.i386.rpm	`68733f637388d81ef68c411ed70b43b7`
rh-postgresql-docs-7.3.21-2.i386.rpm	`82d61d4ffb715cc2a409dcec5a8eaa2e`
rh-postgresql-jdbc-7.3.21-2.i386.rpm	`e7984167bb4cbce7028ec586494177a5`
rh-postgresql-libs-7.3.21-2.i386.rpm	`46d7c730734cbb317b1acc701e372a06`
rh-postgresql-pl-7.3.21-2.i386.rpm	`60d750aeecbe18dfa9699a46ae95d2ac`
rh-postgresql-python-7.3.21-2.i386.rpm	`f6f76927348581d90dee592d76ac73b7`
rh-postgresql-server-7.3.21-2.i386.rpm	`098ea5ed779cbdcc10dce20906270e24`
rh-postgresql-tcl-7.3.21-2.i386.rpm	`ae5b965acf8b4bcbce45d50ce79fb6c5`
rh-postgresql-test-7.3.21-2.i386.rpm	`4c3d9dddaa6c0a36c65375f35c2680c8`

IA-64:
rh-postgresql-7.3.21-2.ia64.rpm	`f1ec42961731d07c049d818e7eb8c04a`
rh-postgresql-contrib-7.3.21-2.ia64.rpm	`beb3fabcab7da2b1ff3852be471879e7`
rh-postgresql-devel-7.3.21-2.ia64.rpm	`1126c8543de0b36bfc290633044da56b`
rh-postgresql-docs-7.3.21-2.ia64.rpm	`0f87fdb2088d5f440ae786e29e2db13a`
rh-postgresql-jdbc-7.3.21-2.ia64.rpm	`0d28e91d6676c9a247eed8cdc24cf75a`
rh-postgresql-libs-7.3.21-2.i386.rpm	`46d7c730734cbb317b1acc701e372a06`
rh-postgresql-libs-7.3.21-2.ia64.rpm	`399ca38a0f28ab4484e90bbb5b5e4946`
rh-postgresql-pl-7.3.21-2.ia64.rpm	`9f6d3ee1e1eeea4c1516dee93c6de02a`
rh-postgresql-python-7.3.21-2.ia64.rpm	`607cf2e04a1f8679bbdecaf170d9956f`
rh-postgresql-server-7.3.21-2.ia64.rpm	`549891f26c4335f4574c48210f2b9453`
rh-postgresql-tcl-7.3.21-2.ia64.rpm	`6938ac2665ef734987e5cd3f27375332`
rh-postgresql-test-7.3.21-2.ia64.rpm	`f2120b8093b2a62fd9cf9419725308ac`

x86_64:
rh-postgresql-7.3.21-2.x86_64.rpm	`8d9ab0a506886c0870af249d5df3e4be`
rh-postgresql-contrib-7.3.21-2.x86_64.rpm	`3f946cba9fcc23e83fa056bef36235d7`
rh-postgresql-devel-7.3.21-2.x86_64.rpm	`bf421cfd0eec0fe3048faaebe3a341e8`
rh-postgresql-docs-7.3.21-2.x86_64.rpm	`6e9342b17cfc09a7399d371b31d57b8f`
rh-postgresql-jdbc-7.3.21-2.x86_64.rpm	`b51b2413b347653342fccd2a878d516f`
rh-postgresql-libs-7.3.21-2.i386.rpm	`46d7c730734cbb317b1acc701e372a06`
rh-postgresql-libs-7.3.21-2.x86_64.rpm	`200c39262d844b43c17d7fd95947a57a`
rh-postgresql-pl-7.3.21-2.x86_64.rpm	`b20c1951ef6fedee01f5df4c8ce8e2b8`
rh-postgresql-python-7.3.21-2.x86_64.rpm	`6df12da5d2d878cfde318d059c33b037`
rh-postgresql-server-7.3.21-2.x86_64.rpm	`807b2dea6c5d5df51dd77ee866ded8db`
rh-postgresql-tcl-7.3.21-2.x86_64.rpm	`4eb3503690445593d789c70651a085a1`
rh-postgresql-test-7.3.21-2.x86_64.rpm	`f587c9460f8f614bb51d167cb31916bd`

Red Hat Enterprise Linux WS (v. 3)

SRPMS:
rh-postgresql-7.3.21-2.src.rpm	`dc3bbd2ec9f5787a82766cb90046a03f`

IA-32:
rh-postgresql-7.3.21-2.i386.rpm	`0cd688f9eaea20bfd701e73fb2dfb924`
rh-postgresql-contrib-7.3.21-2.i386.rpm	`c31b5321b0b41480564321d7fd98abc2`
rh-postgresql-devel-7.3.21-2.i386.rpm	`68733f637388d81ef68c411ed70b43b7`
rh-postgresql-docs-7.3.21-2.i386.rpm	`82d61d4ffb715cc2a409dcec5a8eaa2e`
rh-postgresql-jdbc-7.3.21-2.i386.rpm	`e7984167bb4cbce7028ec586494177a5`
rh-postgresql-libs-7.3.21-2.i386.rpm	`46d7c730734cbb317b1acc701e372a06`
rh-postgresql-pl-7.3.21-2.i386.rpm	`60d750aeecbe18dfa9699a46ae95d2ac`
rh-postgresql-python-7.3.21-2.i386.rpm	`f6f76927348581d90dee592d76ac73b7`
rh-postgresql-server-7.3.21-2.i386.rpm	`098ea5ed779cbdcc10dce20906270e24`
rh-postgresql-tcl-7.3.21-2.i386.rpm	`ae5b965acf8b4bcbce45d50ce79fb6c5`
rh-postgresql-test-7.3.21-2.i386.rpm	`4c3d9dddaa6c0a36c65375f35c2680c8`

IA-64:
rh-postgresql-7.3.21-2.ia64.rpm	`f1ec42961731d07c049d818e7eb8c04a`
rh-postgresql-contrib-7.3.21-2.ia64.rpm	`beb3fabcab7da2b1ff3852be471879e7`
rh-postgresql-devel-7.3.21-2.ia64.rpm	`1126c8543de0b36bfc290633044da56b`
rh-postgresql-docs-7.3.21-2.ia64.rpm	`0f87fdb2088d5f440ae786e29e2db13a`
rh-postgresql-jdbc-7.3.21-2.ia64.rpm	`0d28e91d6676c9a247eed8cdc24cf75a`
rh-postgresql-libs-7.3.21-2.i386.rpm	`46d7c730734cbb317b1acc701e372a06`
rh-postgresql-libs-7.3.21-2.ia64.rpm	`399ca38a0f28ab4484e90bbb5b5e4946`
rh-postgresql-pl-7.3.21-2.ia64.rpm	`9f6d3ee1e1eeea4c1516dee93c6de02a`
rh-postgresql-python-7.3.21-2.ia64.rpm	`607cf2e04a1f8679bbdecaf170d9956f`
rh-postgresql-server-7.3.21-2.ia64.rpm	`549891f26c4335f4574c48210f2b9453`
rh-postgresql-tcl-7.3.21-2.ia64.rpm	`6938ac2665ef734987e5cd3f27375332`
rh-postgresql-test-7.3.21-2.ia64.rpm	`f2120b8093b2a62fd9cf9419725308ac`

x86_64:
rh-postgresql-7.3.21-2.x86_64.rpm	`8d9ab0a506886c0870af249d5df3e4be`
rh-postgresql-contrib-7.3.21-2.x86_64.rpm	`3f946cba9fcc23e83fa056bef36235d7`
rh-postgresql-devel-7.3.21-2.x86_64.rpm	`bf421cfd0eec0fe3048faaebe3a341e8`
rh-postgresql-docs-7.3.21-2.x86_64.rpm	`6e9342b17cfc09a7399d371b31d57b8f`
rh-postgresql-jdbc-7.3.21-2.x86_64.rpm	`b51b2413b347653342fccd2a878d516f`
rh-postgresql-libs-7.3.21-2.i386.rpm	`46d7c730734cbb317b1acc701e372a06`
rh-postgresql-libs-7.3.21-2.x86_64.rpm	`200c39262d844b43c17d7fd95947a57a`
rh-postgresql-pl-7.3.21-2.x86_64.rpm	`b20c1951ef6fedee01f5df4c8ce8e2b8`
rh-postgresql-python-7.3.21-2.x86_64.rpm	`6df12da5d2d878cfde318d059c33b037`
rh-postgresql-server-7.3.21-2.x86_64.rpm	`807b2dea6c5d5df51dd77ee866ded8db`
rh-postgresql-tcl-7.3.21-2.x86_64.rpm	`4eb3503690445593d789c70651a085a1`
rh-postgresql-test-7.3.21-2.x86_64.rpm	`f587c9460f8f614bb51d167cb31916bd`

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

Bugs fixed (see bugzilla for more information)

522085 - CVE-2009-3230 postgresql: SQL privilege escalation, incomplete fix for CVE-2007-6600

References

http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2009-3230
http://www.redhat.com/security/updates/classification/#moderate

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/