pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedFw: postgres logging
2+ messages / 2 participants
[nested] [flat]
* Fw: postgres logging
@ 2004-01-23 12:18 Stef <svb@ucs.co.za>
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-24 05:11 A.Bhuvaneswaran <bhuvan@symonds.net>
parent: Stef <svb@ucs.co.za>
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