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

Re: Fw: postgres logging

From: "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net>
To: Stef <svb(at)ucs(dot)co(dot)za>
Cc: pgsql-admin(at)postgresql(dot)org,"pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Fw: postgres logging
Date: 2004-01-24 05:11:35
Message-ID: 1074921094.1630.1.camel@Bhuvan.bksys.co.in (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

In response to

pgsql-admin by date

Next:From: Martinelli Paolo A.Date: 2004-01-24 10:10:52
Subject: R: Can't connect to phppgadmin
Previous:From: Mark KirkwoodDate: 2004-01-24 03:27:04
Subject: Re: High Performance/High Reliability File system on SuSE64

pgsql-sql by date

Next:From: David ArnoldDate: 2004-01-24 06:24:37
Subject: An order by question
Previous:From: Rajesh Kumar MallahDate: 2004-01-23 18:16:30
Subject: Re: [SQL] Database diagram

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