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

Re: conditional logging based on client

From: Shane Ambler <pgsql(at)Sheeky(dot)Biz>
To: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>
Subject: Re: conditional logging based on client
Date: 2008-07-22 18:47:51
Message-ID: 48862B57.2050402@Sheeky.Biz (view raw or flat)
Thread:
Lists: pgsql-admin
Achilleas Mantzios 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

I am thinking that is a bit more than what you want. You can log all sql
statements run on a server but the server can't differentiate between
your custom-app sent sql and hand made sql sent through psql.

I know you can add things like remote address, username, dbname,
sessionid to the start of each log line but I don't know of getting the
client app name.


My thought would be to enable the statement logging and to modify your
client apps to have a set comment at the beginning and end of all sql
statements sent. You could then filter these sql statements out of the
logs leaving you with hand crafted sql.



-- 

Shane Ambler
pgSQL (at) Sheeky (dot) Biz

Get Sheeky @ http://Sheeky.Biz

In response to

pgsql-admin by date

Next:From: Francisco ReyesDate: 2008-07-22 19:30:21
Subject: Re: [ADMIN] shared_buffers and shmmax
Previous:From: Rajesh Kumar MallahDate: 2008-07-22 17:40:11
Subject: Re: conditional logging based on client

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