Error Message column does not exist about serilog-ui HOT 4 CLOSED

to help others I got this to work with serilog.sinks.postgresql.alternative

Add column writer definitions

IDictionary<string, ColumnWriterBase> columnWriters = new Dictionary<string, ColumnWriterBase>
{
{"message", new RenderedMessageColumnWriter(NpgsqlDbType.Text) },
{"message_template", new MessageTemplateColumnWriter(NpgsqlDbType.Text) },
{"level", new LevelColumnWriter(false, NpgsqlDbType.Integer) },
{"timestamp", new TimestampColumnWriter(NpgsqlDbType.Timestamp) },
{"exception", new ExceptionColumnWriter(NpgsqlDbType.Text) },
{"log_event", new LogEventSerializedColumnWriter(NpgsqlDbType.Jsonb) }
};

the configure with the writers

            loggerConfiguration.WriteTo.PostgreSQL(
                dbSettings["ConnectionString"] ?? "",
                tableName: "logs",
                columnWriters,
                needAutoCreateTable: true,
                schemaName: "public");

Then the normal usage of serilog-ui will work fine.
It matches the lower-case of the column names and schema

from serilog-ui.

Thanks for reporting the issue. The current PostgreSQL data provider is based on the serilog-sinks-postgresql sink and we need to introduce a new package for serilog.sinks.postgresql.alternative sink because they use a different table schema for saving logs.

from serilog-ui.

AH thanks, had to use the alternative for another issue.
Thanks again for the quick answer.
Will keep a on the look out for the support to alterative

from serilog-ui.

Please upgrade Serilog.UI.PostgreSqlProvider nuget package to version 2.3.0.

from serilog-ui.