Horton

Re: log sql?

Neil Conway <nconway@klamath.dyndns.org>

View thread View on postgr.es
From: nconway@klamath.dyndns.org (Neil Conway)
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Andrew Sullivan <andrew@libertyrms.info>, pgsql-general@postgresql.org
Date: 2002-07-30T14:12:08Z
Lists: pgsql-general 
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