Re: Log query results? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Log query results?
Date
Msg-id 15682.1076479430@sss.pgh.pa.us
Whole thread Raw
In response to Log query results?  (Robert Creager <Robert_Creager@LogicalChaos.org>)
Responses Re: Log query results?  (Robert Creager <Robert_Creager@LogicalChaos.org>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Robert Creager
Date:
Subject: Log query results?
Next
From: Mark Lubratt
Date:
Subject: IDE and write cache