| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Logging: statements and users |
| Date: | 2003-11-14 14:34:36 |
| Message-ID: | 20031114143436.GA27483@libertyrms.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-11-14 14:47:23 | Re: Problem with compilation 7.3.4 |
| Previous Message | Dani Oderbolz | 2003-11-14 14:10:57 | Re: pg_atoi: zero-length string |