Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group