by No, we don't. Right now you have to add log_connections, then link the
query pid back to the user connection. Not sure how else we would do it
because log_duration has to do the same linking. Ideas?
---------------------------------------------------------------------------
> Do we have log_username as an option? Would log the username that tried to
> execute each query?
> Would be a useful option!
> Chris
> > -----Original Message-----
> > - CVS
> > Sent: Monday, 2 September 2002 7:26 AM
> > Subject: [COMMITTERS] pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm ...
> > CVSROOT: /cvsroot
> > Module name: pgsql-server
> > Modified files:
> > doc/src/sgml : func.sgml runtime.sgml
> > src/backend/tcop: postgres.c
> > src/backend/utils/misc: guc.c postgresql.conf.sample
> > src/bin/psql : tab-complete.c
> > src/include/utils: guc.h
> > Log message:
> > Add log_duration to GUC/postgresql.conf.
> > Rename debug_print_query to log_statement and rename
> > show_query_stats to
> > show_statement_stats.
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> message can get through to the mailing list cleanly
Bruce Momjian | http://candle.pha.pa.us
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org