On 27/08/14 18:53, Andres Freund wrote:
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:
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

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't have 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.

Yes, as demonstrated by https://github.com/mpihlak/pg_logforward

 Petr Jelinek                  http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to