Re: Turning on logging - Mailing list pgsql-general

From Bill Moran
Subject Re: Turning on logging
Date
Msg-id 20070603085848.a7505018.wmoran@potentialtech.com
Whole thread Raw
In response to Turning on logging  (Owen Hartnett <owen@clipboardinc.com>)
List pgsql-general
Owen Hartnett <owen@clipboardinc.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

pgsql-general by date:

Previous
From: Andrej Kastrin
Date:
Subject: Strange delimiters problem
Next
From: "hubert depesz lubaczewski"
Date:
Subject: Re: Strange delimiters problem