logging

From: Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: logging
Date: 2008-10-03 22:16:11
Message-ID: B0D7C0A3F35FE144A70312D086CBCA9BF75C2048@ExchMailbox2.univ.dir.wwu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

  • Re: logging at 2008-10-06 08:17:26 from IJS/System - Joko

Browse pgsql-admin by date

  From Date Subject
Next Message Mohammed Rashid 2008-10-06 06:23:41 Postgres database as a client/server architecture
Previous Message Yauheni Labko 2008-10-03 20:12:13 Re: pg_dump and roles