Re: Logging

Поиск
Список
Период
Сортировка
От Brett W. McCoy
Тема Re: Logging
Дата
Msg-id Pine.LNX.4.30.0111301002080.3357-100000@chapelperilous.net
обсуждение исходный текст
Ответ на Logging  ("Duncan Adams (DNS)" <duncan.adams@vcontractor.co.za>)
Список pgsql-novice
On Fri, 30 Nov 2001, Duncan Adams  (DNS) wrote:

> I was wondering if there is any way to track/log what sql commands have been
> send to the postgres database from an external source. For example, from a
> PHP/pearl script.

Yes, there is.  I believe if you set DEBUG_PRINT_QUERY in postgresql.conf,
it will log the queries.

See http://www.postgresql.org/idocs/index.php?runtime-config.html#LOGGING
for more details.

-- Brett
                                          http://www.chapelperilous.net/
------------------------------------------------------------------------
The turtle lives 'twixt plated decks
Which practically conceal its sex.
I think it clever of the turtle
In such a fix to be so fertile.
        -- Ogden Nash


В списке pgsql-novice по дате отправления:

Предыдущее
От: "Rob Arnold"
Дата:
Сообщение: Re: Learning to read explain
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Using temp tables with web apps (No State)