From: | "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com> |
---|---|
To: | "Achilleas Mantzios" <achill(at)matrix(dot)gatewaynet(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: conditional logging based on client |
Date: | 2008-07-22 17:40:11 |
Message-ID: | a97c77030807221040n4a791582tb098b0ba9c54944c@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Shane Ambler | 2008-07-22 18:47:51 | Re: conditional logging based on client |
Previous Message | Tom Lane | 2008-07-22 14:45:59 | Re: [ADMIN] shared_buffers and shmmax |