Re: conditional logging based on client

On Tue, Jul 22, 2008 at 5:54 PM, Achilleas Mantzios
<achill(at)matrix(dot)gatewaynet(dot)com> wrote:
> Στις Tuesday 22 July 2008 15:17:42 ο/η Rajesh Kumar Mallah έγραψε:
>> Hi,
>>
>> We want to log all SQLs that has been executed by using psql client.
>> we do not want to use .psql_history as it is distributed and may be
>> deleted by users .
>>
>> The original objective is that we should be able to know what all hand made
>> SQLs have been executed in past (which can date back as long as 1 year even)
>
> You have to adjust log_statement in your postgresql.conf
> however you will have to bear in mind the performance implications of this.
> Normal production sites dont do this.
> You can enable/disable this kind of logging any time by killing -HUP

thanks for reply.
any hit on performance is not desired.
is it possible to alter logging behaviour just for the
psql session ?

>>
>> regds
>> Mallah.
>>
>
>
>
> --
> Achilleas Mantzios
>