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

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: How could we make it simple to access the log as a table?
Date: 2012-05-22 00:53:55
Message-ID: 4FBAE3A3.1030101@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hackers,

There's a lot of great information in the postgres logs. While we
eventually want to get more sophisticated about providing users with
status and history information, for 9.3 it would be really nice to just
offer the current logs in system view format.

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?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2012-05-22 00:59:34 Re: How could we make it simple to access the log as a table?
Previous Message Andrew Dunstan 2012-05-22 00:41:59 Re: Schema version management