Andrew Sullivan wrote:
> 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).
Andrew, what postgresql.conf parameter is query logging. I don't see
it. I see:
#log_connections = false
#log_timestamp = false
#log_pid = false
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026