On Tue, Jul 22, 2008 at 5:54 PM, Achilleas Mantzios
> Στις Tuesday 22 July 2008 15:17:42 ο/η Rajesh Kumar Mallah έγραψε:
>> 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 ?
> Achilleas Mantzios
In response to
pgsql-admin by date
|Next:||From: Shane Ambler||Date: 2008-07-22 18:47:51|
|Subject: Re: conditional logging based on client|
|Previous:||From: Tom Lane||Date: 2008-07-22 14:45:59|
|Subject: Re: [ADMIN] shared_buffers and shmmax |