Proposal: Adding json logging

From: David Arnold <dar(at)xoe(dot)solutions>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Proposal: Adding json logging
Date: 2018-04-14 00:00:16
Message-ID: CAH6vsWLM4tD_jUEPQvihraMReBfr+gN+r_-GdPgbVvjuZZQBCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

*Hello,*

I'm new here. I'm David and would describe myself as an ambitious newbie,
so please take my suggestion with a grain of salt.

*Use case:*
I find it difficult to properly parse postgres logs into some kind of log
aggregator (I use fluent bit). My two standard option are standard and
csvlog.

I have reviewed some log samples and all DO contain some kind of multi line
logs which are very uncomfortable to parse reliably in a log streamer.

I asked Michael Paquier about his solution:
https://github.com/michaelpq/pg_plugins/tree/master/jsonlog
He was suggestion to take action and propose this extension again to be
included in contrib:
https://github.com/michaelpq/pg_plugins/issues/24

He mentioned the argument was rised of taking too much place.
This is true under the paradigm that logs are consumed by TTY or grep,
however, if those logs are to be stored in a logging solution, this is not
really of concern.

Please let me know if you need more context on my use case.

That beeing said the proposal is to accept this library into postgres
contrib.

Please let me know, if I should prepare a patch.

*Best Regards,*

David A.
--
[image: XOE Solutions] <http://xoe.solutions/> DAVID ARNOLD
Gerente General
xoe.solutions
dar(at)xoe(dot)solutions
+57 (315) 304 13 68
*Confidentiality Note: * This email may contain confidential and/or private
information. If you received this email in error please delete and notify
sender.
*Environmental Consideration: * Please avoid printing this email on paper,
unless really necessary.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2018-04-14 03:24:37 Re: Proposal: Adding json logging
Previous Message Michael Paquier 2018-04-13 22:40:07 Re: Native partitioning tablespace inheritance