PRETENDING TO BE POSTGRESQL: PART ONE

Summary from the TLDR Web Dev newsletter

This walkthrough teaches readers how to build a simple PostgreSQL server impersonator in Python. It’s a useful exercise in understanding the PostgreSQL protocol and studying attack patterns. The server mimics the initial PostgreSQL handshake sequence, including authentication, and successfully fools the psql client into thinking it's a PostgreSQL server.