Re: PostgreSQL roadmap for 8.2 and beyond. - Mailing list pgsql-hackers

From Andreas Pflug
Subject Re: PostgreSQL roadmap for 8.2 and beyond.
Date
Msg-id 4354C096.4060703@pse-consulting.de
Whole thread Raw
In response to Re: PostgreSQL roadmap for 8.2 and beyond.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:

>Patrick Bakker <patrick@vanbelle.com> writes:
>  
>
>>It would be useful if you could toggle SQL statement logging without
>>restarting PostgreSQL and additionally if you could turn on selective SQL
>>logging. Additionally, it would be great if you could log SQL statements to
>>a separate file from the main log and in such a way that the statements are
>>seperated in an easily parsed form.
>>    
>>
>
>  
>
>>The runtime toggling of statement logging would also be most useful if you
>>could toggle it outside of a particular session. This is where the selective
>>SQL logging would be useful I think. Some selectable options that could be
>>useful:
>> - by database
>> - by user
>> - by IP address
>>    
>>
>
>You do realize that the majority of that can be done today?  You need to
>study the available mechanism for setting GUC parameters a little more.
>  
>
Not quite, if you want to set it on databases you're not connected to, 
i.e. if you want to 'tap' a backend.

Regards,
Andreas



pgsql-hackers by date:

Previous
From: sandeep satpal
Date:
Subject: Problem in ExecEvalExpr function
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Problem in ExecEvalExpr function