Patrick Bakker <[EMAIL PROTECTED]> 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. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org