Re: Turning on logging

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Owen Hartnett" <owen(at)clipboardinc(dot)com>
Cc: "pgsql-general General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Turning on logging
Date: 2007-06-03 06:16:56
Message-ID: 162867790706022316v19638e3fn911c59d9fb0e4c0a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2007/6/3, Owen Hartnett <owen(at)clipboardinc(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message PFC 2007-06-03 07:41:58 Re: Transactional DDL
Previous Message Greg Smith 2007-06-03 04:46:24 Re: PITR Base Backup on an idle 8.1 server