👁 Image
CSharpEssentials.LoggerHelper.Sink.Postgresql 5.1.0

CSharpEssentials.LoggerHelper.Sink.Postgresql

PostgreSQL structured log storage with JSONB support and custom columns for CSharpEssentials.LoggerHelper.

Part of the CSharpEssentials.LoggerHelper ecosystem — install only the sinks you need.

Install

dotnet add package CSharpEssentials.LoggerHelper
dotnet add package CSharpEssentials.LoggerHelper.Sink.Postgresql

Quick Setup — JSON

{
 "LoggerHelper": {
 "ApplicationName": "MyApp",
 "Routes": [
 { "Sink": "Postgresql", "Levels": ["Warning", "Error", "Fatal"] }
 ],
 "Sinks": {
 "Postgresql": {
 "ConnectionString": "Host=localhost;Database=logs;Username=app;Password=secret",
 "TableName": "app_logs",
 "NeedAutoCreateTable": true
 }
 }
 }
}

builder.Services.AddLoggerHelper(builder.Configuration);

Quick Setup — Fluent API

builder.Services.AddLoggerHelper(b => b
 .WithApplicationName("MyApp")
 .AddRoute("Postgresql", LogEventLevel.Warning, LogEventLevel.Error, LogEventLevel.Fatal)
 .ConfigurePostgreSql(p => {
 p.ConnectionString = "Host=localhost;Database=logs;Username=app;Password=secret";
 p.TableName = "app_logs";
 p.NeedAutoCreateTable = true;
 })
);

Configuration Options

Default Columns

When Columns is not specified, the sink creates these columns automatically:

ApplicationName, message, message_template, level, raise_date, exception, properties, MachineName, Action, IdTransaction

PostgreSqlColumnConfig

Links

• Documentation
• CSharpEssentials.LoggerHelper (core)
• GitHub Repository
• MIT License