pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedLogging
4+ messages / 3 participants
[nested] [flat]
* Logging
@ 2001-11-30 09:39 Duncan Adams (DNS) <duncan.adams@vcontractor.co.za>
2001-11-30 10:08 ` Re: [NOVICE] Logging Markus Bertheau <twanger@bluetwanger.de>
2001-11-30 15:04 ` Re: Logging Brett W. McCoy <bmccoy@chapelperilous.net>
0 siblings, 2 replies; 4+ messages in thread
From: Duncan Adams (DNS) @ 2001-11-30 09:39 UTC (permalink / raw)
To: Pgsql Novice <pgsql-novice@postgresql.org>
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [NOVICE] Logging
2001-11-30 09:39 Logging Duncan Adams (DNS) <duncan.adams@vcontractor.co.za>
@ 2001-11-30 10:08 ` Markus Bertheau <twanger@bluetwanger.de>
1 sibling, 0 replies; 4+ messages in thread
From: Markus Bertheau @ 2001-11-30 10:08 UTC (permalink / raw)
To: Duncan Adams (DNS) <duncan.adams@vcontractor.co.za>; +Cc: pgsql-sql
On Fri, 2001-11-30 at 10:39, Duncan Adams (DNS) wrote:
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
if the corresponding configuration options in postgresql.conf
(esp. debug_print_query) are enabled, the postmaster outputs log
messages on std output. You can redirect these into a log file.
Markus Bertheau
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Logging
2001-11-30 09:39 Logging Duncan Adams (DNS) <duncan.adams@vcontractor.co.za>
@ 2001-11-30 15:04 ` Brett W. McCoy <bmccoy@chapelperilous.net>
1 sibling, 0 replies; 4+ messages in thread
From: Brett W. McCoy @ 2001-11-30 15:04 UTC (permalink / raw)
To: Duncan Adams (DNS) <duncan.adams@vcontractor.co.za>; +Cc: Pgsql Novice <pgsql-novice@postgresql.org>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [NOVICE] Logging
@ 2001-11-30 12:39 Duncan Adams (DNS) <duncan.adams@vcontractor.co.za>
0 siblings, 0 replies; 4+ messages in thread
From: Duncan Adams (DNS) @ 2001-11-30 12:39 UTC (permalink / raw)
To: pgsql-sql
thanx that put me on the right path. that lead me to:
http://postgres.mousetech.com/#LogOptions
thanx again
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2001-11-30 15:04 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-11-30 09:39 Logging Duncan Adams (DNS) <duncan.adams@vcontractor.co.za>
2001-11-30 10:08 ` Markus Bertheau <twanger@bluetwanger.de>
2001-11-30 15:04 ` Brett W. McCoy <bmccoy@chapelperilous.net>
2001-11-30 12:39 Re: [NOVICE] Logging Duncan Adams (DNS) <duncan.adams@vcontractor.co.za>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox