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

From Craig Ringer
Subject Re: Help with tracking!
Date
Msg-id 4BCE3F59.30708@postnewspapers.com.au
Whole thread Raw
In response to Re: Help with tracking!  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Help with tracking!  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
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.

--
Craig Ringer

pgsql-general by date:

Previous
From: Andy
Date:
Subject: Re: Performance impact of log streaming replication
Next
From: Craig Ringer
Date:
Subject: Re: Performance impact of log streaming replication