postgresql
The postgresql identity: PostgreSQL Wire Protocol. Every field and what is required.
postgresql is the PostgreSQL wire protocol. The target is host:port (default 5432). The step sends and receives raw bytes as hex, and the session persists across steps, so a solution can stage an exchange and continue it.
Write it in English
A step reads as sentences, the same byte-session forms as tcp: send hex "<hex>" (or send hex of "<text>"), receive <n> bytes, receive until "<hex>", port <n>, timeout <n> seconds, close the connection, and expect ....
Fields
postgresql uses the byte-session fields from tcp:
| field | required | what it does |
|---|---|---|
send | yes | the bytes to send, as hex or hex "text"; empty when a step only reads |
recv | how many bytes to read at most | |
recv_until | stop reading once this hex marker appears | |
timeout | how long to wait, in seconds | |
close | end the session after this step | |
capture | pull a value out of the received hex for later steps |
Example
postgresql ssl-request
# request an SSL connection and look for the single-byte response
send hex "0000000804d2162f"
recv 1
expect "53" in the response