Description
A flaw was discovered in postgresql versions 9.4.x before 9.4.24, 9.5.x before 9.5.19, 9.6.x before 9.6.15, 10.x before 10.10 and 11.x before 11.5 where arbitrary SQL statements can be executed given a suitable SECURITY DEFINER function. An attacker, with EXECUTE permission on the function, can execute arbitrary SQL as the owner of the function.
Affected products
| Vendor | Product | Affected | Fixed |
|---|---|---|---|
| PostgreSQL | postgresql | all 11.x before 11.5, all 10.x before 10.10, all 9.6.x before 9.6.15, all 9.5.x before 9.5.19, all 9.4.x before 9.4.24 | — |
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 10 | postgresql-11 | 11.5-1+deb10u1 | DSA-4493-1 |
| Debian 9 | postgresql-9.6 | 9.6.15-0+deb9u1 | DSA-4492-1 |
| Debian 8 | postgresql-9.4 | 9.4.24-0+deb8u1 | DLA-1874-1 |
Ubuntu
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Ubuntu 18.04 LTS | postgresql-10 | 10.10-0ubuntu0.18.04.1 | USN-4090-1 |
| Ubuntu 16.04 LTS | postgresql-9.5 | 9.5.19-0ubuntu0.16.04.1 | USN-4090-1 |
Show 1 more (older releases, extended support, other products)Fewer releases
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Ubuntu Pro 14.04 LTS | postgresql-9.3 | No fix yet | — |
Red Hat
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| RHEL 8 | postgresql +10 | 9.6.20-1.module+el8.3.0+8938+7f0e88b6 | RHSA-2020:5619, RHSA-2020:3669 |
| RHEL 8 | postgresql-upgrade +1 | 10.14-1.module+el8.2.0+7801+be0fed80 | RHSA-2020:3669 |
| RHEL 7 | postgresql +11 | 9.2.24-6.el7_9 | RHSA-2021:1512 |
| RHEL 3 | rh-postgresql10-postgresql +13 | 10.12-2.el7 | RHSA-2020:0980 |
| RHEL 3 | rh-postgresql96-postgresql +13 | 9.6.19-1.el7 | RHSA-2020:4295 |
Show 3 more (older releases, extended support, other products)Fewer releases
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| RHEL 8.2 EUS | postgresql +10 | 9.6.20-1.module+el8.2.0+8939+9a3b4b64 | RHSA-2021:0164 |
| RHEL 8.1 EUS | postgresql +10 | 9.6.20-1.module+el8.1.0+9156+8ff1384f | RHSA-2021:0167, RHSA-2021:0166 |
| RHEL 8.1 EUS | postgresql-upgrade +1 | 10.15-1.module+el8.1.0+9154+cd474635 | RHSA-2021:0166 |
| RHEL 8.0 E4S | postgresql +10 | 9.6.20-1.module+el8.0.0+9157+356b8def | RHSA-2020:5664, RHSA-2020:5661 |
| RHEL 8.0 E4S | postgresql-upgrade +1 | 10.15-1.module+el8.0.0+9155+4a85661a | RHSA-2020:5664 |
SUSE
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| SLES 15 SP1 | postgresql10 | 10.10-8.6.1 | SUSE-SU-2019:2707-1 |
| SLES 15 | postgresql10 | 10.10-4.16.1 | SUSE-SU-2019:2228-1 |
| SLES 12 SP3 | postgresql96 +1 | 9.6.15-3.29.1 | SUSE-SU-2019:2159-1 |
| SLES 12 SP2 | postgresql94 | 9.4.24-21.25.1 | SUSE-SU-2019:2158-1 |
| SLES 12 SP2 | postgresql96 +1 | 9.6.15-3.29.1 | SUSE-SU-2019:2159-1 |
| SLES 12 SP1 | postgresql94 | 9.4.24-21.25.1 | SUSE-SU-2019:2158-1 |
| SLES 12 SP1 | postgresql96 +1 | 9.6.15-3.29.1 | SUSE-SU-2019:2159-1 |
Show 9 more (older releases, extended support, other products)Fewer releases
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| SLES for SAP 12 SP3 | postgresql96 +1 | 9.6.15-3.29.1 | SUSE-SU-2019:2159-1 |
| SLES for SAP 12 SP2 | postgresql94 | 9.4.24-21.25.1 | SUSE-SU-2019:2158-1 |
| SLES for SAP 12 SP2 | postgresql96 +1 | 9.6.15-3.29.1 | SUSE-SU-2019:2159-1 |
| SLES for SAP 12 SP1 | postgresql94 | 9.4.24-21.25.1 | SUSE-SU-2019:2158-1 |
| SLES for SAP 12 SP1 | postgresql96 +1 | 9.6.15-3.29.1 | SUSE-SU-2019:2159-1 |
| SUSE OpenStack Cloud Crowbar 8 | postgresql96 +1 | 9.6.15-3.29.1 | SUSE-SU-2019:2159-1 |
| SUSE OpenStack Cloud 8 | postgresql96 +1 | 9.6.15-3.29.1 | SUSE-SU-2019:2159-1 |
| SUSE OpenStack Cloud 7 | postgresql94 | 9.4.24-21.25.1 | SUSE-SU-2019:2158-1 |
| SUSE OpenStack Cloud 7 | postgresql96 +1 | 9.6.15-3.29.1 | SUSE-SU-2019:2159-1 |
| SUSE HPE Helion OpenStack 8 | postgresql96 +1 | 9.6.15-3.29.1 | SUSE-SU-2019:2159-1 |
| SUSE Enterprise Storage 5 | postgresql96 +1 | 9.6.15-3.29.1 | SUSE-SU-2019:2159-1 |
| SUSE Enterprise Storage 4 | postgresql94 | 9.4.24-21.25.1 | SUSE-SU-2019:2158-1 |
| SUSE Enterprise Storage 4 | postgresql96 +1 | 9.6.15-3.29.1 | SUSE-SU-2019:2159-1 |
openSUSE
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| openSUSE Tumbleweed | postgresql10 | 10.18-1.3 | openSUSE-SU-2024:11184-1 |
| openSUSE Tumbleweed | postgresql11 | 11.13-1.3 | openSUSE-SU-2024:11185-1 |
| openSUSE Leap 15.1 | postgresql | 12.0.1-lp151.6.9.1 | openSUSE-SU-2020:1227-1 |
| openSUSE Leap 15.1 | postgresql10 | 10.10-lp151.2.6.1 | openSUSE-SU-2020:1227-1, openSUSE-SU-2019:2062-1 |
| openSUSE Leap 15.1 | postgresql12 | 12.3-lp151.2.1 | openSUSE-SU-2020:1227-1 |
| openSUSE Leap 15.1 | postgresql96 | 9.6.19-lp151.3.3.1 | openSUSE-SU-2020:1227-1 |
| openSUSE Leap 15.0 | postgresql10 | 10.10-lp151.2.6.1 | openSUSE-SU-2019:2062-1 |
Alpine
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Alpine v3.20 | postgresql14 +1 | 11.5-r0 | — |
| Alpine v3.19 | postgresql14 +1 | 11.5-r0 | — |
| Alpine v3.18 | postgresql14 +1 | 11.5-r0 | — |
| Alpine v3.17 | postgresql14 +1 | 11.5-r0 | — |
| Alpine v3.16 | postgresql14 | 11.5-r0 | — |
Show 9 more (older releases, extended support, other products)Fewer releases
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Alpine v3.15 | postgresql14 | 11.5-r0 | — |
| Alpine v3.14 | postgresql | 11.5-r0 | — |
| Alpine v3.13 | postgresql | 11.5-r0 | — |
| Alpine v3.12 | postgresql | 11.5-r0 | — |
| Alpine v3.11 | postgresql | 11.5-r0 | — |
| Alpine v3.10 | postgresql | 11.5-r0 | — |
| Alpine v3.9 | postgresql | 11.5-r0 | — |
| Alpine v3.8 | postgresql | 10.10-r0 | — |
| Alpine v3.7 | postgresql | 10.10-r0 | — |
Amazon Linux
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Amazon Linux 2 | postgresql +11 | 9.2.24-6.amzn2 | ALAS2-2021-1665 |
Oracle Linux
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Oracle Linux 8 | postgresql +12 | 10.14-1.module+el8.2.0+7785+0ea9f177 | ELSA-2020-3669 |
| Oracle Linux 7 | postgresql +11 | 9.2.24-6.el7_9 | ELSA-2021-1512 |
| Oracle Linux 7 | rh-postgresql10-postgresql +13 | 10.15-1.el7 | ELSA-2021-9290 |
Advisories 27
- RHSA-2021:1512 Red Hat Security Advisory: postgresql security update Red Hat Security Advisories (RHSA) · Aug 5, 2026
- RHSA-2021:0167 Red Hat Security Advisory: postgresql:9.6 security update Red Hat Security Advisories (RHSA) · Aug 5, 2026
- RHSA-2021:0166 Red Hat Security Advisory: postgresql:10 security update Red Hat Security Advisories (RHSA) · Aug 5, 2026
- RHSA-2021:0164 Red Hat Security Advisory: postgresql:9.6 security update Red Hat Security Advisories (RHSA) · Aug 5, 2026
- RHSA-2020:5664 Red Hat Security Advisory: postgresql:10 security update Red Hat Security Advisories (RHSA) · Aug 5, 2026
- RHSA-2020:5661 Red Hat Security Advisory: postgresql:9.6 security update Red Hat Security Advisories (RHSA) · Aug 5, 2026
- RHSA-2020:5619 Red Hat Security Advisory: postgresql:9.6 security update Red Hat Security Advisories (RHSA) · Aug 5, 2026
- RHSA-2020:4295 Red Hat Security Advisory: rh-postgresql96-postgresql security update Red Hat Security Advisories (RHSA) · Aug 5, 2026
- RHSA-2020:3669 Red Hat Security Advisory: postgresql:10 security and bug fix update Red Hat Security Advisories (RHSA) · Aug 5, 2026
- RHSA-2020:0980 Red Hat Security Advisory: rh-postgresql10-postgresql security update Red Hat Security Advisories (RHSA) · Aug 5, 2026
- USN-4090-1 postgresql-10, postgresql-11, postgresql-9.5 vulnerabilities Ubuntu Security Notices (USN) · Apr 22, 2026
- DSA-4492-1 postgresql-9.6 - security update Debian Security (DSA / DLA) · Mar 9, 2026
- DSA-4493-1 postgresql-11 - security update Debian Security (DSA / DLA) · Mar 9, 2026
- DLA-1874-1 postgresql-9.4 - security update Debian Security (DSA / DLA) · Mar 9, 2026
- SUSE-SU-2019:2158-1 Security update for postgresql94 SUSE / openSUSE Security Updates · Feb 4, 2026
- openSUSE-SU-2024:11185-1 postgresql11-11.13-1.3 on GA media SUSE / openSUSE Security Updates · Feb 4, 2026
- SUSE-SU-2019:2707-1 Security update for postgresql10 SUSE / openSUSE Security Updates · Feb 4, 2026
- SUSE-SU-2019:2159-1 Security update for postgresql96 SUSE / openSUSE Security Updates · Feb 4, 2026
- openSUSE-SU-2019:2062-1 Security update for postgresql10 SUSE / openSUSE Security Updates · Feb 4, 2026
- openSUSE-SU-2024:11184-1 postgresql10-10.18-1.3 on GA media SUSE / openSUSE Security Updates · Feb 4, 2026
- SUSE-SU-2019:2228-1 Security update for postgresql10 SUSE / openSUSE Security Updates · Feb 4, 2026
- openSUSE-SU-2020:1227-1 Security update for postgresql96, postgresql10 and postgresql12 SUSE / openSUSE Security Updates · May 7, 2025
- WID-SEC-2022-1380 PostgreSQL: Mehrere Schwachstellen BSI CERT-Bund (WID) · Dec 23, 2024
- ALAS2-2021-1665 Important: postgresql security update (Amazon Linux 2) Amazon Linux Security Center (ALAS) · Jun 22, 2021
- ELSA-2021-9290 Important: rh-postgresql10-postgresql security update (Oracle Linux 7) Oracle Linux Security Advisories (ELSA) · Jun 11, 2021
- ELSA-2021-1512 Important: postgresql security update (Oracle Linux 7) Oracle Linux Security Advisories (ELSA) · May 6, 2021
- ELSA-2020-3669 Moderate: postgresql:10 security and bug fix update (Oracle Linux 8) Oracle Linux Security Advisories (ELSA) · Sep 9, 2020