Re: Turning on logging - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Turning on logging
Date
Msg-id 162867790706022316v19638e3fn911c59d9fb0e4c0a@mail.gmail.com
Whole thread Raw
In response to Performance  (Donald Laurine <Donald.Laurine@noaa.gov>)
List pgsql-general
2007/6/3, Owen Hartnett <owen@clipboardinc.com>:
>
> I know this is in the docs somewhere, and it's probably staring me in
> the face, but I haven't been able to find it:
>
> I'm running 8.2.4 through npgsql - how do I log:
>
> 1) connections to the database
>
> 2) updates, deletes, adds
>
>

Hello,

look postgresql.conf in your data directory and set

log_connection = on
log_statement = 'mod'

Regards
Pavel

pgsql-general by date:

Previous
From: Owen Hartnett
Date:
Subject: Turning on logging
Next
From: PFC
Date:
Subject: Re: Transactional DDL