Re: log sql? - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: log sql?
Date
Msg-id 20020729084413.A8252@mail.libertyrms.com
Whole thread Raw
In response to log sql?  (Laurette Cisneros <laurette@nextbus.com>)
Responses Re: log sql?
List 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@libertyrms.info>                              M6K 3E3
                                         +1 416 646 3304 x110


pgsql-general by date:

Previous
From: Tourtounis Sotiris
Date:
Subject: Problematic Index Scan
Next
From: Darren Ferguson
Date:
Subject: Re: Limit on updates made in a transaction