Re: [NOVICE] Logging

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za>
Cc: postgres sql list <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [NOVICE] Logging
Date: 2001-11-30 10:08:14
Message-ID: 1007114894.11088.13.camel@entwicklung01.cenes.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice 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(at)postgresql(dot)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

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 KUMARI,GEETHA-PRESENNA (HP-India,ex2) 2001-11-30 12:07:20 Multibyte support
Previous Message Duncan Adams (DNS) 2001-11-30 09:39:45 Logging

Browse pgsql-sql by date

  From Date Subject
Next Message MindTerm 2001-11-30 10:20:51 Any available solution to port CONNECT BY of oracle to postgresql
Previous Message Duncan Adams (DNS) 2001-11-30 09:39:45 Logging