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

From Stephen Frost
Subject Re: How could we make it simple to access the log as a table?
Date
Msg-id 20120522005934.GI1267@tamriel.snowman.net
Whole thread Raw
In response to How could we make it simple to access the log as a table?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: How could we make it simple to access the log as a table?
List pgsql-hackers
Josh,

* Josh Berkus (josh@agliodbs.com) wrote:
> Certainly this can be done ad-hoc using CSV format and csv_fdw.
> However, such setups are fragile due to log rotation and other issues.
> It seems like we could come up with a better way.  Ideas?

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.

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.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: How could we make it simple to access the log as a table?
Next
From: Robert Haas
Date:
Subject: Re: heap metapages