From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [COMMITTERS] pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm |
Date: | 2002-09-02 01:43:58 |
Message-ID: | 200209020143.g821hwq09404@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
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(at)postgresql(dot)org
> > [mailto:pgsql-committers-owner(at)postgresql(dot)org]On Behalf Of Bruce Momjian
> > - CVS
> > Sent: Monday, 2 September 2002 7:26 AM
> > To: pgsql-committers(at)postgresql(dot)org
> > Subject: [COMMITTERS] pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm ...
> >
> >
> > CVSROOT: /cvsroot
> > Module name: pgsql-server
> > Changes by: momjian(at)postgresql(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-09-02 02:13:02 | pgsql-server/src backend/commands/view.c backe ... |
Previous Message | Christopher Kings-Lynne | 2002-09-02 01:38:27 | Re: [COMMITTERS] pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm ... |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-09-02 02:28:34 | 7.3 status |
Previous Message | Christopher Kings-Lynne | 2002-09-02 01:38:27 | Re: [COMMITTERS] pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm ... |