Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group