Proxy server with logging of user requests

Question

PostgreSQL

It is necessary to make sure that all user requests to multiple databases go through one proxy server and are logged somewhere (well, except for SELECT queries).
pgbouncer can't do that, pg_pool can't do that either.
Tell me where to dig?

Answer 1

Log to CSV files (http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html). Postgres itself can save from CSV to tables. Allocate a separate LOG server (Postgres) where all logs will be collected.
Profit

Answer 2

Perhaps it will help someone to save man
-hours: The only proxy server with support for request logging turned out to be tsung-recorder. And even he is not suitable for such a task due to the fact that he writes logs exclusively in xml format without time stamps and without information about the user.
The problem itself could not be solved.

Answer 3

Um, how about integrating logging into the client application for the employee?