alert http $EXTERNAL_NET any -> $HOME_NET any (
msg:"ET WEB_SPECIFIC_APPS PostgreSQL pgAdmin4 Authenticated Remote Code Execution (CVE-2025-2945) M1";
flow:established,to_server;
http.method;
content:"POST";
http.uri;
content:"/sqleditor/query_tool/download/"; fast_pattern; startswith;
http.cookie;
content:"pga4_session|3d|";
http.request_body; strip_whitespace;
content:"|22|query_committed|22 3a 22|";
pcre:"/^(?:(?!\x22?(?:1|true)).)+[\x22\x2c\x7d]/R";
reference:url,py0zz1.tistory.com/entry/Remote-Code-Execution-Vulnerability-in-pgAdmin-CVE-2025-2945;
reference:cve,2025-2945;
classtype:web-application-attack;
sid:2061374; rev:2;
metadata:affected_product PostgreSQL, attack_target Server, created_at 2025_04_08, cve CVE_2025_2945, deployment Perimeter, deployment Internal, confidence High, signature_severity Major, tag Exploit, updated_at 2026_07_30, mitre_tactic_id TA0001, mitre_tactic_name Initial_Access, mitre_technique_id T1190, mitre_technique_name Exploit_Public_Facing_Application;
target:dest_ip;
)