Re: Similar to csvlog but not really, json logs? - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Similar to csvlog but not really, json logs?
Date
Msg-id 20140827165328.GM21544@awork2.anarazel.de
Whole thread Raw
In response to Re: Similar to csvlog but not really, json logs?  (Jim Nasby <jim@nasby.net>)
Responses Re: Similar to csvlog but not really, json logs?
List pgsql-hackers
On 2014-08-26 23:04:48 -0500, Jim Nasby wrote:
> On 8/26/14, 8:45 PM, Michael Paquier wrote:
> >Hi all,
> >
> >As mentioned here, we support multiple logging format:
> >http://www.postgresql.org/docs/devel/static/runtime-config-logging.html
> >Now what about a json format logging with one json object per log entry?
> >
> >A single json entry would need more space than a csv one as we need to
> >track the field names with their values. Also, there is always the
> >argument that if an application needs json-format logs, it could use
> >csvlog on Postgres-side and do the transformation itself. But wouldn't
> >it be a win for application or tools if such an option is available
> >in-core?
> >
> >Note that I am not planning to work on that in a close future, but it
> >would be a good TODO item for beginners if it is worth pursuing.
> 
> Perhaps instead of doing this in-core it would be better to make log handling more extensible? I'm thinking add a
specific"binary" format and an external tool that can parse that and do whatever the user wants with it. That means we
don'thave to keep adding more complexity to the internal log handling (which already has the risk of being a
bottleneck),while allowing maximum user flexibility.
 

There's a logging hook. Most of this should be doable from there.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: delta relations in AFTER triggers
Next
From: Thomas Munro
Date:
Subject: Re: SKIP LOCKED DATA (work in progress)