Thread: 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
Attachment
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