Log query results?

[Robert Creager]

Hey All,

I'm running 7.4.1 and am having problem when my app starts loading up on the
database. I want to verify the data coming back from the queries is correct
from the server side (not application side), as then I'll be sure my app is
squirrelly (or the db is).

I don't see any options in postgresql.conf that would allow this, but was
wondering if any of the debug levels might get me what I want. Or is there a
better way?

Thanks,
Rob

[Tom Lane]

Post by Robert Creager
I'm running 7.4.1 and am having problem when my app starts loading up on the
database. I want to verify the data coming back from the queries is correct
from the server side (not application side), as then I'll be sure my app is
squirrelly (or the db is).
I don't see any options in postgresql.conf that would allow this, but was
wondering if any of the debug levels might get me what I want. Or is there a
better way?

Nothing on the backend side that I can think of. If you're using libpq
then you could use PQtrace, though that's really intended for debugging
libpq itself. Or you could point a packet sniffer at the TCP
connection.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Robert Creager]

When grilled further on (Wed, 11 Feb 2004 01:03:50 -0500),

Post by Tom Lane
Nothing on the backend side that I can think of. If you're using libpq
then you could use PQtrace, though that's really intended for debugging
libpq itself. Or you could point a packet sniffer at the TCP
connection.

Kind of what I thought. Any (relatively) easy way to hack the
backend/re-compile to have it log the data (all the time)?

Thanks,
Rob