nlog config配置

<?xml version="1.0" encoding="utf-8" ?>
<nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd"
      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      autoReload="true"
      internalLogLevel="info"
      throwException ="true"
      internalLogFile="logs/internal-nlog.txt">    //日志的错误位置文件

  <variable name="logDirectory" value="${basedir}/logs"/>
  <!-- the targets to write to -->
  <targets async="true">
    <!-- write logs to file  -->
    <target xsi:type="File" name="allfile" fileName="${logDirectory}/nlog-all-${shortdate}.log"
            layout="${longdate}|${event-properties:item=EventId_Id}|${uppercase:${level}}|${logger}|${message} ${exception:format=tostring}" />

    <!-- another file log, only own logs. Uses some ASP.NET core renderers -->
    <target xsi:type="File" name="ownFile-web" fileName="${logDirectory}/nlog-own-${shortdate}.log"
            layout="${longdate}|${event-properties:item=EventId_Id}|${uppercase:${level}}|${logger}|${message} ${exception:format=tostring}" />
    <!--|url: ${aspnet-request-url}|action: ${aspnet-mvc-action}-->

    <!-- write log message to database -->
    <!--<target name="db"  xsi:type="AsyncWrapper" queueLimit="5000" overflowAction="Discard">-->
    <target type="Database" name="db" dbProvider="Npgsql.NpgsqlConnection,Npgsql"    《这里的数据库名字注意查找》connectionString="Database=backofficev2;Host=*;User Id=*;Password=*;pooling=false;port=*;">
      <commandText>  //使用postgresql 这里的字段要加双引号，timestamp要将string类型的转换为timestamp类型
        INSERT INTO "SystemLog"("Source","Level","Content","CreatedAt") VALUES(@source, @level, @content, TO_TIMESTAMP(@createdAt, 'YYYY-MM-DD HH24:MI:SS'));
      </commandText> 
      <!-- database connection parameters  ${logger}  Server-->   <-数据库中要写的字段->
      <parameter name="@source" layout="Server" />
      <parameter name="@level" layout="${level}" />
      <parameter name="@content" layout="${message}" />
      <parameter name="@createdAt" layout="${date}" />
    </target>
    <!--</target>-->

  </targets>

  <!-- rules to map from logger name to target -->
  <rules>
   <!--TRACE,DEBUG,INFO,WARN,ERROR,FATAL警告级别控制-->  
    <logger name="*" minlevel="Trace" writeTo="allfile" />
    <!--INFO,WARN,ERROR,FATAL-->
    <logger name="AiEcgWebApi.Controllers.*" minlevel="Warn" writeTo="db" />
    <!--DEBUG,INFO,WARN,ERROR,FATAL-->
    <logger name="*" minlevel="Debug" writeTo="ownFile-web" />   
  </rules>
</nlog>