Обсуждение: Log query results?

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

--
 19:43:51 up 2 days,  6:34,  3 users,  load average: 2.08, 2.17, 2.18

Robert Creager <Robert_Creager@LogicalChaos.org> writes:
> 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

When grilled further on (Wed, 11 Feb 2004 01:03:50 -0500),
Tom Lane <tgl@sss.pgh.pa.us> confessed:

> Robert Creager <Robert_Creager@LogicalChaos.org> writes:
>
> 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

--
 05:53:30 up 2 days, 16:43,  3 users,  load average: 2.08, 2.20, 2.23