.Net Core 8 NLog连接PostgreSQL数据库

最近在做的项目需要把日志记录到本地和数据库，我使用的是NLog，主要参考博文链接：.NET项目中NLog的配置与使用 - 追逐时光者 - 博客园，下面是NLog连接PostgreSQL数据库的步骤，网上关于NLog连接PostgreSQL数据库的实例比较少，大多数都是mysql的。

1、创建Nlog.config配置文件，将下面配置文件内容复制进去，里面包含了存储数据库和本地。

<?xml version="1.0" encoding="utf-8" ?>
<nlog xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
      xmlns="http://www.nlog-project.org/schemas/NLog.xsd"
>
	<targets>
		<target xsi:type="Database"
                name="pgsql"
                dbProvider="Npgsql.NpgsqlConnection,Npgsql"
                connectionString="database=postgres;server=localhost;port=5432;user id=postgres;password=123456;">
			<commandText>
				INSERT INTO syslog (machineName, logged, level, message,logger, callSite, exception)
				VALUES (@machineName, @logged, @level, @message, @logger, @callSite, @exception)
			</commandText>
			<parameter name="@machineName" layout="${machinename}"/>
			<parameter name="@logged" layout="${date}"/>
			<parameter name="@level" layout="${level}"/>
			<parameter name="@message" layout="${message}"/>
			<parameter name="@logger" layout="${logger}"/>
			<parameter name="@callSite" layout="${callsite}"/>
			<parameter name="@exception" layout="${exception:tostring}"/>
		</target>
		<target name="asyncFile" xsi:type="AsyncWrapper">
			<!--项目日志保存文件路径说明fileName="${basedir}/保存目录，以年月日的格式创建/${shortdate}/${记录器名称}-${单级记录}-${shortdate}.txt"-->
			<target name="log_file" xsi:type="File"
				fileName="${basedir}/ProjectLogs/${shortdate}/${logger}-${level}-${shortdate}.txt"
				layout="${longdate} | ${message} ${onexception:${exception:format=message} ${newline} ${stacktrace} ${newline}"
				archiveFileName="${basedir}/archives/${logger}-${level}-${shortdate}-{#####}.txt"
				archiveAboveSize="102400"
				archiveNumbering="Sequence"
				concurrentWrites="true"
				keepFileOpen="false" />
		</target>
	</targets>
	<rules>
		<logger name="*" minlevel="Info" writeTo="pgsql"/>
		<logger name="Microsoft.*" minlevel="Info" writeTo="" final="true" />
		<logger name="*" minlevel="Info" writeTo="asyncFile" />
		<logger name="*" minlevel="Warn" writeTo="colorConsole" />
	</rules>
</nlog>

2、安装nuget包

NLog
NLog.Database
Npgsql

3、创建LoggerHelper

/// <summary>
/// nLog使用帮助类
/// </summary>
public class LoggerHelper
{
    /// <summary>
    /// 实例化nLog，即为获取配置文件相关信息(获取以当前正在初始化的类命名的记录器)
    /// </summary>
    private readonly NLog.Logger _logger = LogManager.GetCurrentClassLogger();
 
    private static LoggerHelper _obj;
 
    public static LoggerHelper Logger
    {
        get => _obj ?? (new LoggerHelper());
        set => _obj = value;
    }
 
    #region Debug，调试
    public void Debug(string msg)
    {
        _logger.Debug(msg);
    }
 
    public void Debug(string msg, Exception err)
    {
        _logger.Debug(err, msg);
    }
    #endregion
 
    #region Info，信息
    public void Info(string msg)
    {
        _logger.Info(msg);
    }
 
    public void Info(string msg, Exception err)
    {
        _logger.Info(err, msg);
    }
    #endregion
 
    #region Warn，警告
    public void Warn(string msg)
    {
        _logger.Warn(msg);
    }
 
    public void Warn(string msg, Exception err)
    {
        _logger.Warn(err, msg);
    }
    #endregion
 
    #region Trace，追踪
    public void Trace(string msg)
    {
        _logger.Trace(msg);
    }
 
    public void Trace(string msg, Exception err)
    {
        _logger.Trace(err, msg);
    }
    #endregion
 
    #region Error，错误
    public void Error(string msg)
    {
        _logger.Error(msg);
    }
 
    public void Error(string msg, Exception err)
    {
        _logger.Error(err, msg);
    }
    #endregion
 
    #region Fatal,致命错误
    public void Fatal(string msg)
    {
        _logger.Fatal(msg);
    }
 
    public void Fatal(string msg, Exception err)
    {
        _logger.Fatal(err, msg);
    }
    #endregion

4、生成日志记录表

CREATE TABLE public.syslog (
    machinename varchar(50) NOT NULL,
    "logged" varchar(50) NOT NULL,
    "level" varchar(50) NOT NULL,
    message text NOT NULL,
    logger varchar(250) NULL,
    callsite text NULL,
    "exception" text NULL
);