Re: Logging

From: "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net>
To: "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za>
Cc: Pgsql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Logging
Date: 2001-11-30 15:04:44
Message-ID: Pine.LNX.4.30.0111301002080.3357-100000@chapelperilous.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

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

In response to

  • Logging at 2001-11-30 09:39:45 from Duncan Adams (DNS)

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-11-30 15:07:17 Re: Using temp tables with web apps (No State)
Previous Message Rob Arnold 2001-11-30 13:11:17 Re: Learning to read explain

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Eckermann 2001-11-30 15:38:54 Re: contracting tables
Previous Message Martín Marqués 2001-11-30 13:43:43 variables in procedures