Fw: postgres logging

From: Stef <svb(at)ucs(dot)co(dot)za>
To: pgsql-admin(at)postgresql(dot)org
Cc: pgsql-sql(at)postgresql(dot)org <pgsql-sql(at)postgresql(dot)org>
Subject: Fw: postgres logging
Date: 2004-01-23 12:18:53
Message-ID: 20040123141853.3c6457ef.svb@ucs.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stef 2004-01-23 12:50:23 Re: [SQL] Fw: postgres logging [SOLVED]
Previous Message register 2004-01-23 11:26:17 User attibutes

Browse pgsql-sql by date

  From Date Subject
Next Message Stef 2004-01-23 12:50:23 Re: [SQL] Fw: postgres logging [SOLVED]
Previous Message Greg Stark 2004-01-23 02:23:36 Re: How can I get the last element out of GROUP BY sets?