I'm using PostgreSQL (8.3) with multiple databases... I'm wondering if there is some way to log the queries made only in one of the databases (not all of them).
Or to have one logfile per database...
I know I can use
log_line_prefix = "%d" to log the name of the database, and then filter, but that is not the issue.
Should I maybe use a log_analyzer to get around this ? Do you have any recommendations ?