From: IJS/System - Joko <system@ijs.co.id>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: logging
Date: Mon, 06 Oct 2008 15:17:26 +0700
Message-ID: <48E9C996.5090705@ijs.co.id> (raw)
In-Reply-To: <B0D7C0A3F35FE144A70312D086CBCA9BF75C2048@ExchMailbox2.univ.dir.wwu.edu>
References: <B0D7C0A3F35FE144A70312D086CBCA9BF75C2048@ExchMailbox2.univ.dir.wwu.edu>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: system@ijs.co.id
Subject: Re: logging
In-Reply-To: <48E9C996.5090705@ijs.co.id>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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