Debugging SQL Statements from *any* client(s)

[Reto]

DEBUG5 is not enough to log SQL statements
------------------------------------------

I've set up a courier-imap POP server authenticating against a
PostgreSQL table through authdaemond/authpgsqlrc. I can verify
courier-imap sends its SELECT statement to make a login attempt but
the POP login fails.

I know I'm pretty close to solve this but I have to see exactly how
the applied SELECT statement from courier-imap looks like. Since
debugging courier-imap is a pain, I've run postmaster with the highest
possible debug level but the SQL statements are not being logged yet
:-|

Any advice is very appreciated.

[Tom Lane]

Post by Reto
I've run postmaster with the highest
possible debug level but the SQL statements are not being logged yet

You need to turn on log_statement ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match