Re: [NOVICE] Logging - Mailing list pgsql-sql

From Markus Bertheau
Subject Re: [NOVICE] Logging
Date
Msg-id 1007114894.11088.13.camel@entwicklung01.cenes.de
Whole thread Raw
List 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



pgsql-sql by date:

Previous
From: MindTerm
Date:
Subject: Any available solution to port CONNECT BY of oracle to postgresql
Next
From: Martín Marqués
Date:
Subject: variables in procedures