Обсуждение: Re: [COMMITTERS] pgsql-server/ oc/src/sgml/func.sgml oc/src/sgm ...

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
>

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