Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 61F6137C10E for ; Mon, 6 Oct 2008 05:48:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 02275-05 for ; Mon, 6 Oct 2008 05:48:47 -0300 (ADT) X-Greylist: delayed 00:30:56.565549 by SQLgrey-1.7.6 Received: from unicorn.sby.dnet.net.id (unicorn.sby.dnet.net.id [202.148.11.52]) by postgresql.org (Postfix) with ESMTP id 368B537B9B7 for ; Mon, 6 Oct 2008 05:48:46 -0300 (ADT) Received: from unicorn.sby.dnet.net.id (localhost [127.0.0.1]) by unicorn.sby.dnet.net.id (Postfix) with ESMTP id 322DF23A0769 for ; Mon, 6 Oct 2008 15:17:38 +0700 (WIT) Received: from neptunus.sby.dnet.net.id (neptunus.sby.dnet.net.id [202.148.11.37]) by unicorn.sby.dnet.net.id (Postfix) with ESMTP id 1AD3023A054C for ; Mon, 6 Oct 2008 15:17:37 +0700 (WIT) Received: from ijs.co.id (unknown [202.148.12.194]) by neptunus.sby.dnet.net.id (Postfix) with ESMTP id 8305D97E9C for ; Mon, 6 Oct 2008 15:17:36 +0700 (WIT) Received: from 192.140.6.18 ([192.140.6.18]) (authenticated user edp03@ijs.co.id) by ijs.co.id (ijs.co.id [192.140.6.10]) (MDaemon.PRO.v6.8.5.R) with ESMTP id 42-md50000000009.tmp for ; Mon, 06 Oct 2008 15:17:30 +0700 Message-ID: <48E9C996.5090705@ijs.co.id> Date: Mon, 06 Oct 2008 15:17:26 +0700 From: IJS/System - Joko User-Agent: Thunderbird 2.0.0.16 (Windows/20080708) MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: Re: logging References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------030903000704000907000400" X-Authenticated-Sender: edp03@ijs.co.id X-Spam-Processed: ijs.co.id, Mon, 06 Oct 2008 15:17:30 +0700 (not processed: message from trusted or authenticated source) X-MDRemoteIP: 192.140.6.18 X-Return-Path: system@ijs.co.id X-MDaemon-Deliver-To: pgsql-admin@postgresql.org X-Virus-Scanned: ClamAV using ClamSMTP X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.6 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001, RCVD_NUMERIC_HELO=2.599 X-Spam-Level: ** X-Archive-Number: 200810/18 X-Sequence-Number: 30474 This is a multi-part message in MIME format. --------------030903000704000907000400 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit yes, remove the comment character. And further more, find my email post with subject "log_statement at postgres.conf" Regards, Joko [IT/EDP] PT. Indra Jaya Swastika Phone: +62 31 7481388 Ext 201 http://www.ijs.co.id Marc Fromm wrote: > > We would like to log sql activity from our web pages that use > postgresql databases. > > I read the documentation for 8.1 at postgresql.org. The > postgresql.conf file under the -Where to log- section has > > #log_destination = 'stderr' > > Is stderr the default or do I need to remove the comment symbol to > actually start logging to stderr? > > Are there recommended settings for all the different items in where to > log, when to log, and what to log? > > > > Our goal is to capture errors like when someone claims to have > submitted data, yet it is not in the database, and the record count > skips an increment---5360 then 5362, missing 5361. > > > > Thanks > > > > > > Marc > > > -- If you have any problem with our services , please contact us at 70468146 or e-mail: helpdesk@ijs.co.id PT Indra Jaya Swastika | Jl. Kalianak Barat 57A | +62-31-7481388 --------------030903000704000907000400 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit yes, remove the comment character.

And further more, find my email post with subject "log_statement at postgres.conf"

Regards,
Joko [IT/EDP]
PT. Indra Jaya Swastika
Phone: +62 31 7481388  Ext 201
http://www.ijs.co.id

Marc Fromm wrote:

We would like to log sql activity from our web pages that use postgresql databases.

I read the documentation for 8.1 at postgresql.org. The postgresql.conf file under the -Where to log- section has

#log_destination = 'stderr'

Is stderr the default or do I need to remove the comment symbol to actually start logging to stderr?

Are there recommended settings for all the different items in where to log, when to log, and what to log?

Our goal is to capture errors like when someone claims to have submitted data, yet it is not in the database, and the record count skips an increment—5360 then 5362, missing 5361.

Thanks

Marc

--
If you have any problem with our services ,
please contact us at 70468146 or e-mail: helpdesk@ijs.co.id
PT Indra Jaya Swastika | Jl. Kalianak Barat 57A | +62-31-7481388 --------------030903000704000907000400--