Ctrl-C in psql gives me the heebie-jeebies
Summary
The Neon blog explains how PostgreSQL CancelRequest is sent as an unencrypted Cancel operation, creating a security risk and potential DoS if interception occurs. It covers how CancelRequest works, why psql still uses plaintext, and what mitigations exist, including TLS encryption in libpq, protocol upgrades, and best-practice recommendations. The piece also highlights Neon and Elephantshark as tooling approaches to monitor and map cancellations.