Re: Log query results?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Log query results?
Дата
Msg-id 15682.1076479430@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Log query results?  (Robert Creager <Robert_Creager@LogicalChaos.org>)
Ответы Re: Log query results?  (Robert Creager <Robert_Creager@LogicalChaos.org>)
Список 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 по дате отправления:

Предыдущее
От: Robert Creager
Дата:
Сообщение: Log query results?
Следующее
От: Mark Lubratt
Дата:
Сообщение: IDE and write cache