pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Logging
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