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?
---------------------------------------------------------------------------
Christopher Kings-Lynne wrote:
> 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-----
> > From: pgsql-committers-owner@postgresql.org
> > [mailto:pgsql-committers-owner@postgresql.org]On Behalf Of Bruce Momjian
> > - CVS
> > Sent: Monday, 2 September 2002 7:26 AM
> > To: pgsql-committers@postgresql.org
> > Subject: [COMMITTERS] pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm ...
> >
> >
> > CVSROOT: /cvsroot
> > Module name: pgsql-server
> > Changes by: momjian@postgresql.org 02/09/01 19:26:06
> >
> > 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
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073