Changeset 300

Show
Ignore:
Timestamp:
12/08/11 16:18:38 (2 years ago)
Author:
keith
Message:

Added tailnmail config for use with pgfouine and updated README

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/tools/tailnmail/README

    r297 r300  
    44 
    55tnm9.cfg takes advantage of the %e parameter added in 9.x to add the error codes to postgres log lines. Just make sure the %e is the last item in the log_line_prefix defined in postgresql.conf and set the .tailnmailrc file (where you tell tail_n_mail your log_line_prefix pattern) to NOT include the %e as part of the pattern so it can be matched against. 
     6 
     7tnm9_pgf.cfg is for servers that are also running PGFouine with Postgres 9+. Currently, the only way to get the error code added to the log_line_prefix without breaking PGFouine it is to add another key/value pair to the end where the user/db names are given. This config file is assuming you added it on the end similar to the following example: 
     8log_line_prefix = '%t (%r) [%p]: [%l-1] user=%u,db=%d,e=%e: ' 
     9Then leave the error code section out of your .tailnmailrc file so that tail_n_mail can match against it like this 
     10log_line_prefix = '%t (%r) [%p]: [%l-1] user=%u,db=%d,'