Integer overflow in src/backend/executor/nodeHash.c in PostgreSQL 8.4.1 and earlier, and 8.5 through 8.5alpha2, allows remote authenticated users to cause a denial of service (daemon crash) via a SELECT statement with many LEFT JOIN clauses, related to certain hashtable size calculations.
Affected Software
| Name | Vendor | Start Version | End Version |
|---|---|---|---|
| Postgresql | Postgresql | * | 8.4.1 (including) |
| Postgresql | Postgresql | 8.0 (including) | 8.0 (including) |
| Postgresql | Postgresql | 8.0.0 (including) | 8.0.0 (including) |
| Postgresql | Postgresql | 8.0.1 (including) | 8.0.1 (including) |
| Postgresql | Postgresql | 8.0.2 (including) | 8.0.2 (including) |
| Postgresql | Postgresql | 8.0.3 (including) | 8.0.3 (including) |
| Postgresql | Postgresql | 8.0.4 (including) | 8.0.4 (including) |
| Postgresql | Postgresql | 8.0.5 (including) | 8.0.5 (including) |
| Postgresql | Postgresql | 8.0.6 (including) | 8.0.6 (including) |
| Postgresql | Postgresql | 8.0.7 (including) | 8.0.7 (including) |
| Postgresql | Postgresql | 8.0.8 (including) | 8.0.8 (including) |
| Postgresql | Postgresql | 8.0.9 (including) | 8.0.9 (including) |
| Postgresql | Postgresql | 8.0.10 (including) | 8.0.10 (including) |
| Postgresql | Postgresql | 8.0.11 (including) | 8.0.11 (including) |
| Postgresql | Postgresql | 8.0.12 (including) | 8.0.12 (including) |
| Postgresql | Postgresql | 8.0.13 (including) | 8.0.13 (including) |
| Postgresql | Postgresql | 8.0.14 (including) | 8.0.14 (including) |
| Postgresql | Postgresql | 8.0.15 (including) | 8.0.15 (including) |
| Postgresql | Postgresql | 8.0.16 (including) | 8.0.16 (including) |
| Postgresql | Postgresql | 8.0.17 (including) | 8.0.17 (including) |
| Postgresql | Postgresql | 8.0.18 (including) | 8.0.18 (including) |
| Postgresql | Postgresql | 8.0.19 (including) | 8.0.19 (including) |
| Postgresql | Postgresql | 8.0.20 (including) | 8.0.20 (including) |
| Postgresql | Postgresql | 8.0.21 (including) | 8.0.21 (including) |
| Postgresql | Postgresql | 8.0.22 (including) | 8.0.22 (including) |
| Postgresql | Postgresql | 8.0.23 (including) | 8.0.23 (including) |
| Postgresql | Postgresql | 8.0.24 (including) | 8.0.24 (including) |
| Postgresql | Postgresql | 8.0.317 (including) | 8.0.317 (including) |
| Postgresql | Postgresql | 8.1 (including) | 8.1 (including) |
| Postgresql | Postgresql | 8.1.0 (including) | 8.1.0 (including) |
| Postgresql | Postgresql | 8.1.1 (including) | 8.1.1 (including) |
| Postgresql | Postgresql | 8.1.2 (including) | 8.1.2 (including) |
| Postgresql | Postgresql | 8.1.3 (including) | 8.1.3 (including) |
| Postgresql | Postgresql | 8.1.4 (including) | 8.1.4 (including) |
| Postgresql | Postgresql | 8.1.5 (including) | 8.1.5 (including) |
| Postgresql | Postgresql | 8.1.6 (including) | 8.1.6 (including) |
| Postgresql | Postgresql | 8.1.7 (including) | 8.1.7 (including) |
| Postgresql | Postgresql | 8.1.8 (including) | 8.1.8 (including) |
| Postgresql | Postgresql | 8.1.9 (including) | 8.1.9 (including) |
| Postgresql | Postgresql | 8.1.10 (including) | 8.1.10 (including) |
| Postgresql | Postgresql | 8.1.11 (including) | 8.1.11 (including) |
| Postgresql | Postgresql | 8.1.12 (including) | 8.1.12 (including) |
| Postgresql | Postgresql | 8.1.13 (including) | 8.1.13 (including) |
| Postgresql | Postgresql | 8.1.14 (including) | 8.1.14 (including) |
| Postgresql | Postgresql | 8.1.15 (including) | 8.1.15 (including) |
| Postgresql | Postgresql | 8.1.16 (including) | 8.1.16 (including) |
| Postgresql | Postgresql | 8.1.17 (including) | 8.1.17 (including) |
| Postgresql | Postgresql | 8.1.18 (including) | 8.1.18 (including) |
| Postgresql | Postgresql | 8.1.19 (including) | 8.1.19 (including) |
| Postgresql | Postgresql | 8.1.20 (including) | 8.1.20 (including) |
| Postgresql | Postgresql | 8.2 (including) | 8.2 (including) |
| Postgresql | Postgresql | 8.2.1 (including) | 8.2.1 (including) |
| Postgresql | Postgresql | 8.2.2 (including) | 8.2.2 (including) |
| Postgresql | Postgresql | 8.2.3 (including) | 8.2.3 (including) |
| Postgresql | Postgresql | 8.2.4 (including) | 8.2.4 (including) |
| Postgresql | Postgresql | 8.2.5 (including) | 8.2.5 (including) |
| Postgresql | Postgresql | 8.2.6 (including) | 8.2.6 (including) |
| Postgresql | Postgresql | 8.2.7 (including) | 8.2.7 (including) |
| Postgresql | Postgresql | 8.2.8 (including) | 8.2.8 (including) |
| Postgresql | Postgresql | 8.2.9 (including) | 8.2.9 (including) |
| Postgresql | Postgresql | 8.2.10 (including) | 8.2.10 (including) |
| Postgresql | Postgresql | 8.2.11 (including) | 8.2.11 (including) |
| Postgresql | Postgresql | 8.2.12 (including) | 8.2.12 (including) |
| Postgresql | Postgresql | 8.2.13 (including) | 8.2.13 (including) |
| Postgresql | Postgresql | 8.2.14 (including) | 8.2.14 (including) |
| Postgresql | Postgresql | 8.2.15 (including) | 8.2.15 (including) |
| Postgresql | Postgresql | 8.2.16 (including) | 8.2.16 (including) |
| Postgresql | Postgresql | 8.3 (including) | 8.3 (including) |
| Postgresql | Postgresql | 8.3.1 (including) | 8.3.1 (including) |
| Postgresql | Postgresql | 8.3.2 (including) | 8.3.2 (including) |
| Postgresql | Postgresql | 8.3.3 (including) | 8.3.3 (including) |
| Postgresql | Postgresql | 8.3.4 (including) | 8.3.4 (including) |
| Postgresql | Postgresql | 8.3.5 (including) | 8.3.5 (including) |
| Postgresql | Postgresql | 8.3.6 (including) | 8.3.6 (including) |
| Postgresql | Postgresql | 8.3.7 (including) | 8.3.7 (including) |
| Postgresql | Postgresql | 8.3.8 (including) | 8.3.8 (including) |
| Postgresql | Postgresql | 8.3.9 (including) | 8.3.9 (including) |
| Postgresql | Postgresql | 8.3.10 (including) | 8.3.10 (including) |
| Postgresql | Postgresql | 8.4 (including) | 8.4 (including) |
| Postgresql | Postgresql | 8.5 (including) | 8.5 (including) |
| Postgresql | Postgresql | 8.5-alpha1 (including) | 8.5-alpha1 (including) |
| Postgresql | Postgresql | 8.5-alpha2 (including) | 8.5-alpha2 (including) |
| Red Hat Enterprise Linux 3 | RedHat | rh-postgresql-0:7.3.21-3 | * |
| Red Hat Enterprise Linux 4 | RedHat | postgresql-0:7.4.29-1.el4_8.1 | * |
| Red Hat Enterprise Linux 5 | RedHat | postgresql-0:8.1.21-1.el5_5.1 | * |
| Postgresql-7.4 | Ubuntu | dapper | * |
| Postgresql-8.0 | Ubuntu | dapper | * |
| Postgresql-8.1 | Ubuntu | dapper | * |
| Postgresql-8.1 | Ubuntu | upstream | * |
| Postgresql-8.2 | Ubuntu | hardy | * |
| Postgresql-8.2 | Ubuntu | upstream | * |
| Postgresql-8.3 | Ubuntu | hardy | * |
| Postgresql-8.3 | Ubuntu | intrepid | * |
| Postgresql-8.3 | Ubuntu | jaunty | * |
| Postgresql-8.3 | Ubuntu | karmic | * |
| Postgresql-8.3 | Ubuntu | upstream | * |
| Postgresql-8.4 | Ubuntu | devel | * |
| Postgresql-8.4 | Ubuntu | karmic | * |
| Postgresql-8.4 | Ubuntu | lucid | * |
| Postgresql-8.4 | Ubuntu | maverick | * |
| Postgresql-8.4 | Ubuntu | natty | * |
| Postgresql-8.4 | Ubuntu | oneiric | * |
| Postgresql-8.4 | Ubuntu | upstream | * |
References
- http://archives.postgresql.org/pgsql-bugs/2009-10/msg00277.php
- http://archives.postgresql.org/pgsql-bugs/2009-10/msg00287.php
- http://archives.postgresql.org/pgsql-bugs/2009-10/msg00289.php
- http://archives.postgresql.org/pgsql-bugs/2009-10/msg00310.php
- http://git.postgresql.org/gitweb?p=postgresql.git%3Ba=commit%3Bh=64b057e6823655fb6c5d1f24a28f236b94dd6c54
- http://lists.opensuse.org/opensuse-security-announce/2010-08/msg00001.html
- http://secunia.com/advisories/39820
- http://www.openwall.com/lists/oss-security/2010/03/09/2
- http://www.openwall.com/lists/oss-security/2010/03/16/10
- http://www.redhat.com/support/errata/RHSA-2010-0427.html
- http://www.redhat.com/support/errata/RHSA-2010-0428.html
- http://www.redhat.com/support/errata/RHSA-2010-0429.html
- http://www.securityfocus.com/bid/38619
- http://www.vupen.com/english/advisories/2010/1197
- https://bugzilla.redhat.com/show_bug.cgi?id=546621
- https://oval.cisecurity.org/repository/search/definition/oval%3Aorg.mitre.oval%3Adef%3A10691
- http://archives.postgresql.org/pgsql-bugs/2009-10/msg00277.php
- http://archives.postgresql.org/pgsql-bugs/2009-10/msg00287.php
- http://archives.postgresql.org/pgsql-bugs/2009-10/msg00289.php
- http://archives.postgresql.org/pgsql-bugs/2009-10/msg00310.php
- http://git.postgresql.org/gitweb?p=postgresql.git%3Ba=commit%3Bh=64b057e6823655fb6c5d1f24a28f236b94dd6c54
- http://lists.opensuse.org/opensuse-security-announce/2010-08/msg00001.html
- http://secunia.com/advisories/39820
- http://www.openwall.com/lists/oss-security/2010/03/09/2
- http://www.openwall.com/lists/oss-security/2010/03/16/10
- http://www.redhat.com/support/errata/RHSA-2010-0427.html
- http://www.redhat.com/support/errata/RHSA-2010-0428.html
- http://www.redhat.com/support/errata/RHSA-2010-0429.html
- http://www.securityfocus.com/bid/38619
- http://www.vupen.com/english/advisories/2010/1197
- https://bugzilla.redhat.com/show_bug.cgi?id=546621
- https://oval.cisecurity.org/repository/search/definition/oval%3Aorg.mitre.oval%3Adef%3A10691