As per my understanding when we execute a command or query, the Postgres client sends a frontend message, and in return gets the response in the backend message format.
How do I capture and check these messages on a Linux box?
For e.g. let's say I am executing the below command via
psql --username=foo --dbname=mydb --password=foobar
I believe the client creates StartupMessage.
Is there a way to trace down this interaction? Considering server and client are running on the same machine.