Description
In postgresql 9.3.x before 9.3.21, 9.4.x before 9.4.16, 9.5.x before 9.5.11, 9.6.x before 9.6.7 and 10.x before 10.2, pg_upgrade creates file in current working directory containing the output of `pg_dumpall -g` under umask which was in effect when the user invoked pg_upgrade, and not under 0077 which is normally used for other temporary files. This can allow an authenticated attacker to read or modify the one file, which may contain encrypted or unencrypted database passwords. The attack is infeasible if a directory mode blocks the attacker searching the current working directory or if the prevailing umask blocks the attacker opening the file.
Affected products
| Vendor | Product | Affected | Fixed |
|---|---|---|---|
| The PostgreSQL Global Development Group | postgresql | 9.3.x before 9.3.21, 9.4.x before 9.4.16, 9.5.x before 9.5.11, 9.6.x before 9.6.7, 10.x before 10.2 | — |
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 7 | postgresql-9.1 | 9.1.24lts2-0+deb7u2 | DLA-1271-1 |
Ubuntu
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Ubuntu 16.04 LTS | postgresql-9.5 | 9.5.11-0ubuntu0.16.04 | USN-3564-1 |
| Ubuntu 14.04 LTS | postgresql-9.3 | 9.3.21-0ubuntu0.14.04 | USN-3564-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 |
Show 1 more (older releases, extended support, other products)Fewer releases
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Red Hat CloudForms 5 | cfme | 5.9.6.5-3.el7cf | RHSA-2018:3816 |
| Red Hat CloudForms 5 | cfme-appliance +2 | 5.9.6.5-1.el7cf | RHSA-2018:3816 |
| Red Hat CloudForms 5 | cfme-gemset +1 | 5.9.6.5-2.el7cf | RHSA-2018:3816 |
| Red Hat CloudForms 5 | dbus-api-service | 1.0.1-3.1.el7cf | RHSA-2018:3816 |
| Red Hat CloudForms 5 | httpd-configmap-generator | 0.2.2-1.2.el7cf | RHSA-2018:3816 |
| Red Hat CloudForms 5 | postgresql96 +9 | 9.6.10-1PGDG.el7at | RHSA-2018:3816 |
SUSE
Security tracker ↗| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| SLES 12 SP3 | postgresql96 +1 | 9.6.7-3.13.1 | SUSE-SU-2018:0507-1 |
| SLES 12 SP2 | postgresql94 +1 | 9.4.16-21.16.1 | SUSE-SU-2018:0675-1 |
| SLES 12 SP2 | postgresql96 +1 | 9.6.7-3.13.1 | SUSE-SU-2018:0507-1 |
| SLES 11 SP4 | postgresql94 +1 | 9.4.16-0.23.13.2 | SUSE-SU-2018:0506-1 |
Show 3 more (older releases, extended support, other products)Fewer releases
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| SLES for SAP 12 SP3 | postgresql96 +1 | 9.6.7-3.13.1 | SUSE-SU-2018:0507-1 |
| SLES for SAP 12 SP2 | postgresql94 | 9.4.16-21.16.1 | SUSE-SU-2018:0675-1 |
| SLES for SAP 12 SP2 | postgresql96 +1 | 9.6.7-3.13.1 | SUSE-SU-2018:0507-1 |
| SLES for SAP 11 SP4 | postgresql94 +1 | 9.4.16-0.23.13.2 | SUSE-SU-2018:0506-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.2-r0 | — |
| Alpine v3.19 | postgresql14 +1 | 10.2-r0 | — |
| Alpine v3.18 | postgresql14 +1 | 10.2-r0 | — |
| Alpine v3.17 | postgresql14 +1 | 10.2-r0 | — |
| Alpine v3.16 | postgresql14 | 10.2-r0 | — |
Show 12 more (older releases, extended support, other products)Fewer releases
| Release | Package | Fixed in | Advisory |
|---|---|---|---|
| Alpine v3.15 | postgresql14 | 10.2-r0 | — |
| Alpine v3.14 | postgresql | 10.2-r0 | — |
| Alpine v3.13 | postgresql | 10.2-r0 | — |
| Alpine v3.12 | postgresql | 10.2-r0 | — |
| Alpine v3.11 | postgresql | 10.2-r0 | — |
| Alpine v3.10 | postgresql | 10.2-r0 | — |
| Alpine v3.9 | postgresql | 10.2-r0 | — |
| Alpine v3.8 | postgresql | 10.2-r0 | — |
| Alpine v3.7 | postgresql | 10.2-r0 | — |
| Alpine v3.6 | postgresql | 9.6.7-r0 | — |
| Alpine v3.5 | postgresql | 9.6.7-r0 | — |
| Alpine v3.4 | postgresql | 9.5.11-r0 | — |
Advisories 9
- RHSA-2018:3816 Red Hat Security Advisory: CloudForms 4.6.6 security, bug fix and enhancement update Red Hat Security Advisories (RHSA) · Aug 5, 2026
- 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-3564-1 postgresql-9.3, postgresql-9.5, postgresql-9.6 vulnerability Ubuntu Security Notices (USN) · Apr 22, 2026
- DLA-1271-1 postgresql-9.1 - security update Debian Security (DSA / DLA) · Mar 9, 2026
- SUSE-SU-2018:0675-1 Security update for postgresql94 SUSE / openSUSE Security Updates · Feb 4, 2026
- SUSE-SU-2018:0507-1 Security update for postgresql96 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-2018:0506-1 Security update for postgresql94 SUSE / openSUSE Security Updates · Feb 4, 2026
References
- https://www.postgresql.org/about/news/1829/
- RHSA-2018:2511 vendor-advisory
- [debian-lts-announce] 20180207 [SECURITY] [DLA-1271-1] postgresql-9.1 security update mailing-list
- RHSA-2018:2566 vendor-advisory
- RHSA-2018:3816 vendor-advisory
- 102986 vdb-entry
- USN-3564-1 vendor-advisory