On Tue, Jul 30, 2002 at 12:14:16AM -0400, Bruce Momjian wrote:
> 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.
debug_print_query
Cheers,
Neil
--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC