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.

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
>

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