Elephantshark, a tool to monitor Postgres network traffic
2 days ago
- #Networking
- #Postgres
- #Monitoring
- Elephantshark is an open-source Ruby script for monitoring and troubleshooting Postgres network traffic.
- It sits between Postgres clients and servers, decrypting and re-encrypting SSL/TLS connections to log and annotate messages.
- Elephantshark can also enable Wireshark usage by writing keys to an SSLKEYLOGFILE.
- To use Elephantshark, run it in one terminal and connect to a Postgres database via a modified hostname and SSL settings in another terminal.
- The tool logs detailed message exchanges, including SSL requests, authentication processes, and query executions.
- Elephantshark supports all Postgres-protocol traffic, including connections to Neon databases.