pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Debugging 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