Michael Ben-Nes <miki(at)canaan(dot)co(dot)il> writes:> You can set postgresql.conf to log all queries to a file.> Sadly you cant distinguish between the databases.
See log_line_prefix in 8.0.
regards, tom lane