Thread: Logging

Hi all

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.

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