Re: logging

From: IJS/System - Joko <system(at)ijs(dot)co(dot)id>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: logging
Date: 2008-10-06 08:17:26
Message-ID: 48E9C996.5090705@ijs.co.id
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)ijs(dot)co(dot)id
PT Indra Jaya Swastika | Jl. Kalianak Barat 57A | +62-31-7481388

In response to

  • logging at 2008-10-03 22:16:11 from Marc Fromm

Browse pgsql-admin by date

  From Date Subject
Next Message Guy Deleeuw 2008-10-06 08:32:06 sql command strange behaviour
Previous Message Mohammed Rashid 2008-10-06 06:23:41 Postgres database as a client/server architecture