Re: Turning on logging

Owen Hartnett <owen(at)clipboardinc(dot)com> wrote:
>
>
> 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
>
>
> Is this set in the ./configuration? Or in the startup command line?

It can be specified on the startup command line, but it's much easier
to put it in postgresql.conf:
http://www.postgresql.org/docs/8.2/static/config-setting.html

There are parameters for the specific things you want to control:
http://www.postgresql.org/docs/8.2/static/runtime-config-logging.html

HTH

--
Bill Moran
http://www.potentialtech.com