Thread: Logging: statements and users

Logging: statements and users

From
ow
Date:
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?

Thanks







__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

Re: Logging: statements and users

From
Andrew Sullivan
Date:
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