Index: doc/src/sgml/runtime.sgml =================================================================== RCS file: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v retrieving revision 1.322 diff -c -c -r1.322 runtime.sgml *** doc/src/sgml/runtime.sgml 4 Jun 2005 20:42:41 -0000 1.322 --- doc/src/sgml/runtime.sgml 9 Jun 2005 22:24:15 -0000 *************** *** 2830,2835 **** --- 2830,2840 ---- yes + %h + Remote Hostname or IP address + yes + + %p Process ID no *************** *** 2840,2845 **** --- 2845,2855 ---- no + %m + Timestamp with milliseconds + no + + %i Command tag: This is the command that generated the log line. yes Index: src/backend/utils/error/elog.c =================================================================== RCS file: /cvsroot/pgsql/src/backend/utils/error/elog.c,v retrieving revision 1.158 diff -c -c -r1.158 elog.c *** src/backend/utils/error/elog.c 12 Mar 2005 01:54:44 -0000 1.158 --- src/backend/utils/error/elog.c 9 Jun 2005 22:24:17 -0000 *************** *** 1375,1380 **** --- 1375,1407 ---- case 'l': appendStringInfo(buf, "%ld", log_line_number); break; + case 'm': + { + time_t stamp_time; + char strfbuf[128], msbuf[5]; + struct timeval tv; + + gettimeofday(&tv, NULL); + stamp_time = tv.tv_sec; + + strftime(strfbuf, sizeof(strfbuf), + /* leave room for milliseconds... */ + /* Win32 timezone names are too long so don't print them. */ + #ifndef WIN32 + "%Y-%m-%d %H:%M:%S %Z", + #else + "%Y-%m-%d %H:%M:%S ", + #endif + localtime(&stamp_time)); + + /* 'paste' milliseconds into place... */ + sprintf(msbuf, ".%03d", + (int)(tv.tv_usec/1000)); + strncpy(strfbuf+19, msbuf, 4); + + appendStringInfoString(buf, strfbuf); + } + break; case 't': { /* *************** *** 1426,1431 **** --- 1453,1462 ---- MyProcPort->remote_port); } break; + case 'h': + if (MyProcPort) + appendStringInfo(buf, "%s", MyProcPort->remote_host); + break; case 'q': /* in postmaster and friends, stop if %q is seen */ /* in a backend, just ignore */ Index: src/backend/utils/misc/postgresql.conf.sample =================================================================== RCS file: /cvsroot/pgsql/src/backend/utils/misc/postgresql.conf.sample,v retrieving revision 1.143 diff -c -c -r1.143 postgresql.conf.sample *** src/backend/utils/misc/postgresql.conf.sample 4 Jun 2005 20:42:42 -0000 1.143 --- src/backend/utils/misc/postgresql.conf.sample 9 Jun 2005 22:24:17 -0000 *************** *** 241,248 **** #log_duration = false #log_line_prefix = '' # e.g. '<%u%%%d> ' # %u=user name %d=database name ! # %r=remote host and port # %p=PID %t=timestamp %i=command tag # %c=session id %l=session line number # %s=session start timestamp %x=transaction id # %q=stop here in non-session processes --- 241,249 ---- #log_duration = false #log_line_prefix = '' # e.g. '<%u%%%d> ' # %u=user name %d=database name ! # %r=remote host and port %h=remote host # %p=PID %t=timestamp %i=command tag + # %m=timestamp with milliseconds # %c=session id %l=session line number # %s=session start timestamp %x=transaction id # %q=stop here in non-session processes