Received: from leela.one-2-one.net (leela.one-2-one.net [217.115.142.65]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAUA8am78925 for ; Fri, 30 Nov 2001 05:08:37 -0500 (EST) (envelope-from twanger@bluetwanger.de) Received: from [192.168.0.14] (pD90557D4.dip.t-dialin.net [217.5.87.212]) by leela.one-2-one.net (8.11.0/8.11.0) with ESMTP id fAUA8Ce22173; Fri, 30 Nov 2001 11:08:12 +0100 Subject: Re: [NOVICE] Logging From: Markus Bertheau To: "Duncan Adams (DNS)" Cc: postgres sql list In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-FLYL0KlBjOag/3Qe+9rS" X-Mailer: Evolution/0.99.2 (Preview Release) Date: 30 Nov 2001 11:08:14 +0100 Message-Id: <1007114894.11088.13.camel@entwicklung01.cenes.de> Mime-Version: 1.0 X-Archive-Number: 200111/435 X-Sequence-Number: 5816 --=-FLYL0KlBjOag/3Qe+9rS Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Fri, 2001-11-30 at 10:39, Duncan Adams (DNS) wrote: > Hi all >=20 > I was wondering if there is any way to track/log what sql commands have b= een > send to the postgres database from an external source. For example, from a > PHP/pearl script. >=20 > ---------------------------(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 --=-FLYL0KlBjOag/3Qe+9rS Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQA8B1qOKNEjAb345r4RAkpzAJ44JM6gXZZ/5SafeHHMpRhKDsVFAgCeOc3Z 56vNWTCe2HeYfnjY0Chnl9Q= =uoXH -----END PGP SIGNATURE----- --=-FLYL0KlBjOag/3Qe+9rS--