| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: log sql? |
| Date: | 2002-07-29 12:44:13 |
| Message-ID: | 20020729084413.A8252@mail.libertyrms.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On Fri, Jul 26, 2002 at 03:27:45PM -0700, Laurette Cisneros wrote:
>
> Is there way to track each sql statement and the user for the server?
Sort of. Turn on query logging in the postgresql.conf file, and also
log connections and PID. Then, you can track back by using the PID,
to discovere who logged in (and therefore, who issued that query).
A
--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert M. Meyer | 2002-07-29 13:30:38 | Re: Multiple Postmasters on Beowulf cluster |
| Previous Message | Tahira Aslam | 2002-07-29 10:31:13 | Could not connect to remote socket |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francois Suter | 2002-07-29 12:48:45 | Re: Postgres and Perl: Which DBI module? |
| Previous Message | Darren Ferguson | 2002-07-29 12:41:34 | Re: Limit on updates made in a transaction |