Skip site navigation (1) Skip section navigation (2)

Re: conditional logging based on client

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 (view raw or flat)
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
>

In response to

Responses

pgsql-admin by date

Next:From: Shane AmblerDate: 2008-07-22 18:47:51
Subject: Re: conditional logging based on client
Previous:From: Tom LaneDate: 2008-07-22 14:45:59
Subject: Re: [ADMIN] shared_buffers and shmmax

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group