Re: How could we make it simple to access the log as a table? - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: How could we make it simple to access the log as a table?
Date
Msg-id m28vgciabm.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Re: How could we make it simple to access the log as a table?  (Stephen Frost <sfrost@snowman.net>)
Responses Re: How could we make it simple to access the log as a table?
List pgsql-hackers
Stephen Frost <sfrost@snowman.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Backends stalled in 'startup' state: index corruption
Next
From: Christopher Browne
Date:
Subject: Re: How could we make it simple to access the log as a table?