Search Postgresql Archives

Re: "sniffing" postgres queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



You might be able to get enough information looking at the raw frontend/backend protocol exchange (http://www.postgresql.org/docs/ 8.2/static/protocol.html) using something like tcpflow or Ethereal.



On Mar 20, 2007, at 5:45 PM, Anton Melser wrote:

I am having real trouble with a project that is a little out of my
league and I just can't find out how to find which table the app is
getting its values from (it's a long story...). I know what values I
am looking for, and would like to log everything (even if only for one
call of a web page...) that comes in and everything that goes out. Is
this possible at the db level? Even debug5 doesn't seem to give me the
result of a query... If it is only possible at the driver level (I did
something vaguely similar with the odbc driver I think), then any
pointers for a jdbc2 on 8.1.4?



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux