Re: Application name patch - v2 - Mailing list pgsql-hackers

From Dave Page
Subject Re: Application name patch - v2
Date
Msg-id 937d27e10910190500p3bb31030t849656a9c00fe76@mail.gmail.com
Whole thread Raw
In response to Re: Application name patch - v2  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: Application name patch - v2
Re: Application name patch - v2
List pgsql-hackers
On Mon, Oct 19, 2009 at 12:57 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> It is not practical. I'll log errors. Usually SQL injection generates
> lot of errors. Loging all statements has not sense. What is difference
> bad and good SQL statement.? Maybe multistatements are good candidates
> for log as possible attackers statements. On highly load databases
> loging all statements significantly increase load :(

Ahh, I see.

>> My point is, that the query to change the app name is logged using the
>> *original* app name, thus it will not be discarded by the log analysis
>> tools in your scenario.
>>
>
> I thing, so change of original name should generate warning.

Well, if other people think that's necessary, it's certainly possible.

-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Application name patch - v2
Next
From: daveg
Date:
Subject: Re: Deprecation