Re: How could we make it simple to access the log as a table?

Stephen Frost <sfrost(at)snowman(dot)net> writes:
> This is really where I was hoping to eventually get to with the logging
> changes that have been discussed over the past couple of years. We need
> to have a mechanism to allow logging to different places, based on
> information included in the log message and/or context, where one of
> those places could potentially be some kind of receiver process that
> then dumps the message into a table, either on the local system or on a
> remote system.

That looks like syslog features?

> What exactly all of that looks like and how it works is a pretty big
> discussion, but I'd definitely love to hear from others who are
> interested in changes to our logging infrastructure.

I though about exposing the log CSV files as partitions of a log table,
each partition being a FDW able to read the file.

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support