Description
INSERT ... ON CONFLICT DO UPDATE commands in PostgreSQL 10.x before 10.1, 9.6.x before 9.6.6, and 9.5.x before 9.5.10 disclose table contents that the invoker lacks privilege to read. These exploits affect only tables where the attacker lacks full read access but has both INSERT and UPDATE privileges. Exploits bypass row level security policies and lack of SELECT privilege.
Affected products
| Vendor | Product | Affected | Fixed |
|---|---|---|---|
| Red Hat | postgresql | 10.x before 10.1, 9.6.x before 9.6.6, 9.5.x before 9.5.10 | — |
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 9 | postgresql-9.6 | 9.6.6-0+deb9u1 | DSA-4028-1 |
Ubuntu
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Ubuntu 16.04 LTS | postgresql-9.5 | 9.5.10-0ubuntu0.16.04 | USN-3479-1 |
| Ubuntu 14.04 LTS | postgresql-9.3 | 9.3.20-0ubuntu0.14.04 | USN-3479-1 |
Red Hat
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| RHEL 3 | rh-postgresql95-postgresql +10 | 9.5.14-1.el6 | RHSA-2018:2511 |
| RHEL 3 | rh-postgresql96-postgresql +13 | 9.6.10-1.el6 | RHSA-2018:2566 |
SUSE
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| SLES 12 SP3 | postgresql96 +1 | 9.6.6-3.10.1 | SUSE-SU-2017:3391-1 |
| SLES 12 SP2 | postgresql96 +1 | 9.6.6-3.10.1 | SUSE-SU-2017:3391-1 |
Show 2 more (older releases, extended support, other products)Fewer releases
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| SLES for SAP 12 SP3 | postgresql96 +1 | 9.6.6-3.10.1 | SUSE-SU-2017:3391-1 |
| SLES for SAP 12 SP2 | postgresql96 +1 | 9.6.6-3.10.1 | SUSE-SU-2017:3391-1 |
openSUSE
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| openSUSE Tumbleweed | postgresql10 | 10.18-1.3 | openSUSE-SU-2024:11184-1 |
Alpine
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Alpine v3.20 | postgresql14 +1 | 10.1-r0 | — |
| Alpine v3.19 | postgresql14 +1 | 10.1-r0 | — |
| Alpine v3.18 | postgresql14 +1 | 10.1-r0 | — |
| Alpine v3.17 | postgresql14 +1 | 10.1-r0 | — |
| Alpine v3.16 | postgresql14 | 10.1-r0 | — |
Show 12 more (older releases, extended support, other products)Fewer releases
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Alpine v3.15 | postgresql14 | 10.1-r0 | — |
| Alpine v3.14 | postgresql | 10.1-r0 | — |
| Alpine v3.13 | postgresql | 10.1-r0 | — |
| Alpine v3.12 | postgresql | 10.1-r0 | — |
| Alpine v3.11 | postgresql | 10.1-r0 | — |
| Alpine v3.10 | postgresql | 10.1-r0 | — |
| Alpine v3.9 | postgresql | 10.1-r0 | — |
| Alpine v3.8 | postgresql | 10.1-r0 | — |
| Alpine v3.7 | postgresql | 10.1-r0 | — |
| Alpine v3.6 | postgresql | 9.6.6-r0 | — |
| Alpine v3.5 | postgresql | 9.6.6-r0 | — |
| Alpine v3.4 | postgresql | 9.5.10-r0 | — |
Advisories 7
- RHSA-2018:2566 Red Hat Security Advisory: rh-postgresql96-postgresql security update Red Hat Security Advisories (RHSA) · Aug 5, 2026
- RHSA-2018:2511 Red Hat Security Advisory: rh-postgresql95-postgresql security update Red Hat Security Advisories (RHSA) · Aug 5, 2026
- USN-3479-1 postgresql-9.3, postgresql-9.5, postgresql-9.6 vulnerabilities Ubuntu Security Notices (USN) · Apr 22, 2026
- DSA-4028-1 postgresql-9.6 - security update Debian Security (DSA / DLA) · Mar 9, 2026
- openSUSE-SU-2024:11184-1 postgresql10-10.18-1.3 on GA media SUSE / openSUSE Security Updates · Feb 4, 2026
- SUSE-SU-2017:3391-1 Security update for postgresql96 SUSE / openSUSE Security Updates · Feb 4, 2026
- WID-SEC-2024-0143 PostgreSQL: Mehrere Schwachstellen BSI CERT-Bund (WID) · Jul 31, 2025
References
- 101781 vdb-entry
- RHSA-2018:2511 vendor-advisory
- https://www.postgresql.org/support/security/
- 1039752 vdb-entry
- https://www.postgresql.org/about/news/1801/
- RHSA-2018:2566 vendor-advisory
- DSA-4028 vendor-advisory