pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Fw: postgres logging
2+ messages / 2 participants
[nested] [flat]

* Fw: postgres logging
@ 2004-01-23 12:18 Stef <svb@ucs.co.za>
  2004-01-24 05:11 ` Re: Fw: postgres logging A.Bhuvaneswaran <bhuvan@symonds.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Stef @ 2004-01-23 12:18 UTC (permalink / raw)
  To: pgsql-admin@postgresql.org; +Cc: pgsql-sql

Hi all, 

I've switched on  log_statement in postgresql.conf 
for debugging purposes. I tried logging connections
and pids as well, but I need to match up the logged statements 
to specific connections. 

The postmaster logs to a separate log file, but at the moment
it's impossible to tell which sql comes from which connection.
Is there an easy way to accomplish this?

Kind Regards
Stefan

Attachments:

  00000009.mimetmp (application/pgp-signature, 308B) download

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Fw: postgres logging
  2004-01-23 12:18 Fw: postgres logging Stef <svb@ucs.co.za>
@ 2004-01-24 05:11 ` A.Bhuvaneswaran <bhuvan@symonds.net>
  0 siblings, 0 replies; 2+ messages in thread

From: A.Bhuvaneswaran @ 2004-01-24 05:11 UTC (permalink / raw)
  To: Stef <svb@ucs.co.za>; +Cc: pgsql-sql

> The postmaster logs to a separate log file, but at the moment
> it's impossible to tell which sql comes from which connection.
> Is there an easy way to accomplish this?
> 

The PID of the connected process is prepended to every log statement.
You can make use of this to know which sql comes from which connection.

Regards,
A.Bhuvaneswaran

Attachments:

  signature.asc (application/pgp-signature, 231B) download

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2004-01-24 05:11 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-23 12:18 Fw: postgres logging Stef <svb@ucs.co.za>
2004-01-24 05:11 ` A.Bhuvaneswaran <bhuvan@symonds.net>

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