Tom Lane wrote:
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.
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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
