Carlos Moreno <moreno(at)mochima(dot)com> writes:
> checking the man pages, I came up with:
> tcpdump -i local port 5432
> I then connected using psql -h localhost, as a test;
> it seems to be showing only timing and length information.
I get useful results with
/usr/sbin/tcpdump -x -X -s 0 -i lo port 5432
You do need to use "-h localhost" when connecting with psql.
regards, tom lane