Discussion:
postgres logging
(too old to reply)
Stef
2004-01-23 12:18:53 UTC
Permalink
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
Stef
2004-01-23 12:50:23 UTC
Permalink
Stef mentioned :
=> 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?

Erm... sorry ,

It appears my postgresql.conf is not an original. It didn't have
the log_pid option in. :)

Loading...