Horton

Re: log sql?

Bruce Momjian <pgman@candle.pha.pa.us>

View thread View on postgr.es
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Andrew Sullivan <andrew@libertyrms.info>
Cc: pgsql-general@postgresql.org
Date: 2002-07-30T04:14:16Z
Lists: pgsql-general 
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