Description
PostgreSQL before 9.1.23, 9.2.x before 9.2.18, 9.3.x before 9.3.14, 9.4.x before 9.4.9, and 9.5.x before 9.5.4 allow remote authenticated users to cause a denial of service (NULL pointer dereference and server crash), obtain sensitive memory information, or possibly execute arbitrary code via (1) a CASE expression within the test value subexpression of another CASE or (2) inlining of an SQL function that implements the equality operator used for a CASE expression involving values of different types.
Fixed in Linux distributions
Distributions backport fixes, so the version that fixes this vulnerability differs per release — upgrade to at least the version shown. From the distributions' security trackers and advisories.
Debian
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Debian 8 | postgresql-9.4 | 9.4.9-0+deb8u1 | DSA-3646-1 |
| Debian 7 | postgresql-9.1 | 9.1.23-0+deb7u1 | DLA-592-1 |
Ubuntu
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Ubuntu 16.04 LTS | postgresql-9.5 | 9.5.4-0ubuntu0.16.04 | USN-3066-1 |
| Ubuntu 14.04 LTS | postgresql-9.1 | 9.1.23-0ubuntu0.14.04 | — |
| Ubuntu 14.04 LTS | postgresql-9.3 | 9.3.14-0ubuntu0.14.04 | USN-3066-1 |
Red Hat
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| RHEL 7 | postgresql +10 | 9.2.18-1.el7 | RHSA-2016:2606 |
| RHEL 2 | postgresql92-postgresql +10 | 9.2.18-1.el6 | RHSA-2016:1820 |
| RHEL 2 | rh-postgresql94-postgresql +11 | 9.4.9-1.el6 | RHSA-2016:1781 |
| RHEL 2 | rh-postgresql95-postgresql +10 | 9.5.4-1.el6 | RHSA-2016:1821 |
Show 2 more (older releases, extended support, other products)Fewer releases
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Red Hat Network Satellite Managed Db 5 | rh-postgresql95-postgresql +4 | 9.5.7-2.el6 | RHSA-2017:2425 |
| Red Hat Network Satellite Managed Db 5 | rh-postgresql95-runtime | 2.2-3.el6 | RHSA-2017:2425 |
| Red Hat Network Satellite Managed Db 5 | spacewalk-postgresql-server | 9.5-1.el6sat | RHSA-2017:2425 |
| Red Hat Network Satellite Managed Db 5 | spacewalk-setup-postgresql | 2.3.0-27.el6sat | RHSA-2017:2425 |
| Red Hat Network Satellite Managed Db 5 | spacewalk-web +2 | 2.3.2-35.el6sat | RHSA-2017:2425 |
| Red Hat Network Satellite 5 | rh-postgresql95-postgresql +4 | 9.5.7-2.el6 | RHSA-2017:2425 |
| Red Hat Network Satellite 5 | rh-postgresql95-runtime | 2.2-3.el6 | RHSA-2017:2425 |
| Red Hat Network Satellite 5 | spacewalk-backend +16 | 2.3.3-53.el6sat | RHSA-2017:2425 |
| Red Hat Network Satellite 5 | spacewalk-postgresql-server | 9.5-1.el6sat | RHSA-2017:2425 |
| Red Hat Network Satellite 5 | spacewalk-pxt +8 | 2.3.2-35.el6sat | RHSA-2017:2425 |
| Red Hat Network Satellite 5 | spacewalk-setup-postgresql | 2.3.0-27.el6sat | RHSA-2017:2425 |
| Red Hat Network Satellite 5 | spacewalk-utils | 2.3.2-32.el6sat | RHSA-2017:2425 |
SUSE
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| SLES 12 SP1 | postgresql94 +1 | 9.4.9-14.1 | SUSE-SU-2016:2415-1 |
| SLES 12 | postgresql93 | 9.3.14-19.2 | SUSE-SU-2016:2414-1 |
| SLES 11 SP4 | postgresql94 +1 | 9.4.9-0.19.1 | SUSE-SU-2016:2418-1 |
Show 4 more (older releases, extended support, other products)Fewer releases
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| SLES for SAP 12 SP1 | postgresql94 +1 | 9.4.9-14.1 | SUSE-SU-2016:2415-1 |
| SLES for SAP 12 | postgresql93 | 9.3.14-19.2 | SUSE-SU-2016:2414-1 |
| SLES for SAP 11 SP4 | postgresql94 +1 | 9.4.9-0.19.1 | SUSE-SU-2016:2418-1 |
| SUSE Manager 2.1 | postgresql94 | 9.4.9-0.19.1 | SUSE-SU-2016:2418-1 |
openSUSE
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| openSUSE Tumbleweed | postgresql93 | 9.3.15-1.1 | openSUSE-SU-2024:10256-1 |
| openSUSE Tumbleweed | postgresql94 | 9.4.10-1.1 | openSUSE-SU-2024:10030-1 |
| openSUSE Tumbleweed | postgresql95 | 9.5.4-1.2 | openSUSE-SU-2024:10273-1 |
Oracle Linux
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Oracle Linux 7 | postgresql +10 | 9.2.18-1.el7 | ELSA-2016-2606 |
Advisories 15
- RHSA-2017:2425 Red Hat Security Advisory: rh-postgresql95-postgresql security update Red Hat Security Advisories (RHSA) · Jun 29, 2026
- RHSA-2016:2606 Red Hat Security Advisory: postgresql security and bug fix update Red Hat Security Advisories (RHSA) · Jun 29, 2026
- RHSA-2016:1820 Red Hat Security Advisory: postgresql92-postgresql security update Red Hat Security Advisories (RHSA) · Jun 29, 2026
- RHSA-2016:1821 Red Hat Security Advisory: rh-postgresql95-postgresql security update Red Hat Security Advisories (RHSA) · Jun 29, 2026
- RHSA-2016:1781 Red Hat Security Advisory: rh-postgresql94-postgresql security update Red Hat Security Advisories (RHSA) · Jun 29, 2026
- USN-3066-1 postgresql-9.1, postgresql-9.3, postgresql-9.5 vulnerabilities Ubuntu Security Notices (USN) · Apr 22, 2026
- DLA-592-1 postgresql-9.1 - security update Debian Security (DSA / DLA) · Mar 9, 2026
- DSA-3646-1 postgresql-9.4 - security update Debian Security (DSA / DLA) · Mar 9, 2026
- openSUSE-SU-2024:10030-1 postgresql94-9.4.10-1.1 on GA media SUSE / openSUSE Security Updates · Feb 4, 2026
- SUSE-SU-2016:2418-1 Security update for postgresql94 SUSE / openSUSE Security Updates · Feb 4, 2026
- SUSE-SU-2016:2414-1 Security update for postgresql93 SUSE / openSUSE Security Updates · Feb 4, 2026
- openSUSE-SU-2024:10273-1 libecpg6-32bit-9.5.4-1.2 on GA media SUSE / openSUSE Security Updates · Feb 4, 2026
- SUSE-SU-2016:2415-1 Security update for postgresql94 SUSE / openSUSE Security Updates · Feb 4, 2026
- openSUSE-SU-2024:10256-1 postgresql93-9.3.15-1.1 on GA media SUSE / openSUSE Security Updates · May 7, 2025
- ELSA-2016-2606 Moderate: postgresql security and bug fix update (Oracle Linux 7) Oracle Linux Security Advisories (ELSA) · Nov 9, 2016
References
- RHSA-2016:1781 vendor-advisory
- https://www.postgresql.org/docs/current/static/release-9-4-9.html
- 1036617 vdb-entry
- RHSA-2016:1821 vendor-advisory
- DSA-3646 vendor-advisory
- 92433 vdb-entry
- GLSA-201701-33 vendor-advisory
- RHSA-2017:2425 vendor-advisory
- https://www.postgresql.org/docs/current/static/release-9-5-4.html
- https://www.postgresql.org/docs/current/static/release-9-3-14.html
- https://www.postgresql.org/about/news/1688/
- https://www.postgresql.org/docs/current/static/release-9-2-18.html
- RHSA-2016:2606 vendor-advisory
- RHSA-2016:1820 vendor-advisory
- https://www.postgresql.org/docs/current/static/release-9-1-23.html
- https://bugzilla.redhat.com/show_bug.cgi?id=1364001