logging

--_000_B0D7C0A3F35FE144A70312D086CBCA9BF75C2048ExchMailbox2u ni_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

We would like to log sql activity from our web pages that use postgresql da=
tabases.
I read the documentation for 8.1 at postgresql.org. The postgresql.conf fil=
e under the -Where to log- section has
#log_destination =3D '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 da=
ta, yet it is not in the database, and the record count skips an increment-=
5360 then 5362, missing 5361.

Thanks


Marc


--_000_B0D7C0A3F35FE144A70312D086CBCA9BF75C2048ExchMailbox2u ni_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

hemas-microsoft-com:office:word" xmlns=3D"http://www.w3.org/TR/REC-html40">

Re: logging

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