PostgreSQL Wire Protocol

Creator

Creator

Created

Created

2024 Mar 21 14:57

Editor

Editor

Edited

Edited

2025 May 11 17:44

Refs

Refs

데이터베이스와 클라이언트 간의 통신을 가능하게 하는 프로토콜

Postgres Wire Protocol Implementations

sunng87 • Updated 2025 May 11 10:40

Postgres Extended Protocol

Response

RowDescription

DataRow

CommandComplete

ReadyForQuery

Hacking the Postgres wire protocol

PgDog is a network proxy and it can see every byte sent between Postgres and the clients. It understands SQL and can infer where queries should go, without requiring changes to application code.

Hacking the Postgres wire protocol

https://pgdog.dev/blog/hacking-postgres-wire-protocol

Hacking the Postgres wire protocol

Chapter 53. Frontend/Backend Protocol

Chapter 53. Frontend/Backend Protocol Table of Contents 53.1. Overview 53.1.1. Messaging Overview 53.1.2. Extended Query Overview 53.1.3. Formats and Format Codes 53.2. …

Chapter 53. Frontend/Backend Protocol

https://www.postgresql.org/docs/14/protocol.html

Chapter 53. Frontend/Backend Protocol

Recommendations

////////