pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDebugging SQL Statements from *any* client(s)
2+ messages / 2 participants
[nested] [flat]
* Debugging SQL Statements from *any* client(s)
@ 2004-06-15 09:56 Reto <spam@infocopter.ch>
2004-06-20 13:07 ` Re: Debugging SQL Statements from *any* client(s) Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: spam@infocopter.ch @ 2004-06-15 09:56 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Debugging SQL Statements from *any* client(s)
2004-06-15 09:56 Debugging SQL Statements from *any* client(s) Reto <spam@infocopter.ch>
@ 2004-06-20 13:07 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2004-06-20 13:07 UTC (permalink / raw)
To: spam@infocopter.ch; +Cc: pgsql-admin
spam@infocopter.ch (Reto) writes:
> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-06-20 13:07 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-15 09:56 Debugging SQL Statements from *any* client(s) Reto <spam@infocopter.ch>
2004-06-20 13:07 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox