Postgres Pro
Downloads
Home   >   mailing lists

Re: Logging: statements and users - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: Logging: statements and users
Date
Msg-id 20031114143436.GA27483@libertyrms.info
Whole thread Raw
In response to Logging: statements and users  (ow <oneway_111@yahoo.com>)
List pgsql-admin
Tree view 
On Wed, Nov 12, 2003 at 11:10:09PM -0800, ow wrote:
> Hi,
>
> It appears that pgSql can be configured to log the executed statements.
> However, the log does not appear to contain any info about who's running the
> statement. Any way to change this?

You can log the pid and log connections, and then trace back to see
who connected with that pid.  There was some discussion about
improving this for 7.4, but I don't know if any of that was done.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

pgsql-admin by date:

Previous
From: Dani Oderbolz
Date:
Subject: Re: pg_atoi: zero-length string
Next
From: Tom Lane
Date:
Subject: Re: Problem with compilation 7.3.4