Re: Help with tracking! - Mailing list pgsql-general

From Steve Crawford
Subject Re: Help with tracking!
Date
Msg-id 4BCE4272.9010503@pinpointresearch.com
Whole thread Raw
In response to Re: Help with tracking!  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: Help with tracking!  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Craig Ringer wrote:
> On 20/04/2010 10:33 PM, Scott Marlowe wrote:
>
>>> psql
>>> show log_statement;
>>>   log_statement
>>> ---------------
>>>   all
>>
>> Note however that other sessions won't see the change.  Only
>> connections that come after the change will see it.
>
> Also, as the OP wants to use it for auditing, it's worth noting that
> it's trivial for the audited user to simply disable log_statement in a
> session with a SET command.

 From the docs for log_statement: "Only superusers can change this
setting. "

Cheers,
Steve


pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Performance impact of log streaming replication
Next
From: Craig Ringer
Date:
Subject: Re: Help with tracking!