← Back
CVE-2018-18482
Vulnerability in pg-query (CVE-2018-18482)
Summary
vulnerability in pg-query (CVE-2018-18482). Risk of unauthorized operations or information disclosure. Mitigation: upgrade to `0.28` or later.
AI summary snake-internal / snake-material-v2
A vulnerability tracked as **CVE-2018-18482** has been found in pg-query.
Risk of unauthorized operations or information disclosure. CVSS score: ?/10.
What to do: upgrade pg-query to **0.28** or later.
If unsure, ask your IT team or search "pg-query CVE-2018-18482" on the vendor's site.
CVE-2018-18482 (pg-query) — CWE-772 /
Attack vector: remote (network-reachable) / unauthenticated
Patched: `0.28` — 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** (CWE-772) exists in pg-query.
📍 Affected scope
pg-query — .
🔥 Severity
Severity: ?. Risk of unauthorized operations or information disclosure
🔧 How to fix
Update to **0.28**.
🛡️ 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 'pg-query' .` against your dependency files (package-lock.json, requirements.txt, go.sum) to find affected services.
Response Actions (7 steps)
Concrete steps and command examples for SOC/SRE teams to execute in order
-
1Identify exposure identify
grep -r 'pg-query' . | grep -v node_modulesリポジトリと本番環境の依存ファイル (package-lock.json / requirements.txt / go.sum / Gemfile.lock 等) で `pg-query` を grep し、稼働しているサービス・バージョンを把握する。
-
6Apply patch patch
Upgrade pg-query to 0.28ステージング環境で 0.28 に上げて回帰テスト → 本番反映。回帰テストはアプリの主要ハッピーパスと、Step 3 で見つけた異常検知の続報チェックを含めること。
-
7Post-deployment verification verify
Confirm patched version is live in productionパッチ適用後、ステージングで PoC または同等の悪用パターンを再現して脆弱性が閉じたことを確認。本番では Step 3 と同じログクエリでアラート再発が無いか継続監視。
Affected packages
PyPI
pg-query
[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"0.28"}]}]
PyPI
pglast
[{"type":"ECOSYSTEM","events":[{"introduced":"0"},{"fixed":"0.28"}]}]
References
- advisory https://nvd.nist.gov/vuln/detail/CVE-2018-18482
- advisory https://github.com/advisories/GHSA-vm3q-58wm-2r2x
- package https://github.com/lelit/pglast
- package https://pypi.org/project/pglast
- web https://github.com/lfittl/libpg_query/issues/49
- web https://github.com/pypa/advisory-database/tree/main/vulns/pg-query/PYSEC-2018-154.yaml