Vulnerability in postgresql (ALPINE-CVE-2021-20229)

Summary

Vulnerability in postgresql (ALPINE-CVE-2021-20229). Risk of unauthorized operations or information disclosure. Mitigation: upgrade to 12.6-r0 or later.

Original description

The description as published by the source.

A flaw was found in PostgreSQL in versions before 13.2. This flaw allows a user with SELECT privilege on one column to craft a special query that returns all columns of the table. The highest threat from this vulnerability is to confidentiality.

Source: OSV.dev (Open Source Vulnerabilities) OSV

Auto-generated summary

Assembled by SecPulse from the source data (CVSS, CWE, affected versions) using templates — no AI involved. Check the original description and references below for exact details.

A vulnerability tracked as ALPINE-CVE-2021-20229 has been found in postgresql.
Risk of unauthorized operations or information disclosure.
What to do: upgrade postgresql to 12.6-r0 or later.
If unsure, ask your IT team or search "postgresql ALPINE-CVE-2021-20229" on the vendor's site.

ALPINE-CVE-2021-20229 (postgresql)
Attack vector: remote (network-reachable) / no user interaction
Patched: 12.6-r0 — apply immediately
Plan: 1) Audit SBOM/dependencies, 2) Stage→prod upgrade, 3) Add WAF/proxy monitoring on affected endpoints, 4) Hunt IOCs in logs.
Refs: see the GHSA / vendor advisory / patched release linked on this page.

❓ What is the problem

A vulnerability (unclassified) exists in postgresql.

📍 Affected scope

Check the vendor advisory for the affected versions of postgresql.

🔥 Severity

Severity: ?. Risk of unauthorized operations or information disclosure.

🔧 How to fix

Update to 12.6-r0.

🛡️ Workaround

Until the patch is applied: disable the affected feature, apply WAF rules, or restrict access via network ACLs.

🔍 Detection

Search webserver/proxy logs for unusual request patterns matching this CVE's known IOCs. Run grep -r 'postgresql' . against your dependency files (package-lock.json, requirements.txt, go.sum) to find affected services.

Response actions

Concrete steps and command examples for SOC/SRE teams to execute in order

1
Identify exposure identify
```
grep -r 'postgresql' . | grep -v node_modules
```
リポジトリと本番環境の依存ファイル (package-lock.json / requirements.txt / go.sum / Gemfile.lock 等) で postgresql を grep し、稼働しているサービス・バージョンを把握する。
2
Apply patch patch
```
Upgrade postgresql to 12.6-r0
```
ステージング環境で 12.6-r0 に上げて回帰テスト → 本番反映。回帰テストはアプリの主要ハッピーパスを含めること。
3
Post-deployment verification verify
```
Confirm patched version is live in production
```
パッチ適用後、ステージングで PoC または同等の悪用パターンを再現して脆弱性が閉じたことを確認。本番ではアクセスログ・WAF でアラート再発が無いか継続監視。

Affected packages

Alpine:v3.12 postgresql

[{"type":"ECOSYSTEM","events":[{"introduced":"13.0"},{"fixed":"12.6-r0"}]}]

Alpine:v3.13 postgresql

[{"type":"ECOSYSTEM","events":[{"introduced":"13.0"},{"fixed":"13.2-r0"}]}]

Alpine:v3.14 postgresql

[{"type":"ECOSYSTEM","events":[{"introduced":"13.0"},{"fixed":"13.2-r0"}]}]

Alpine:v3.15 postgresql13