Re: Proposal: Adding json logging

From: David Arnold <dar(at)xoe(dot)solutions>
To: Christophe Pettus <xof(at)thebuild(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: Proposal: Adding json logging
Date: 2018-04-15 18:00:05
Message-ID: CAH6vsWLrqwxffRMM2NCHVHTBA6p9ON5X1rea0j9EL7QaZy+Hzg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>It looks like the thread skipped over the problem space for the solution
space pretty fast

OK, I apologize, it seemed to me from the feedback that the problem was
already uncontested. To verify/falsify that was the objective of my
previous mail :)

>Can you elaborate?

Sure.
CSV Logs: https://pastebin.com/uwfmRdU7
stdout: https://gist.github.com/blaggacao/d389940ef7b223eebc707096b536967d

CSV shows line breaks, STDOUT shows ERROR/FATAL and detail on different
lines, not an easy problem to stream-parse reliably (without some kind of a
buffer, etc)...

El dom., 15 abr. 2018 a las 12:46, Christophe Pettus (<xof(at)thebuild(dot)com>)
escribió:

>
> > On Apr 15, 2018, at 10:39, David Arnold <dar(at)xoe(dot)solutions> wrote:
> >
> > In the light of the specific use case / problem for this thread to be
> born, what exactly would you suggest?
>
> It looks like the thread skipped over the problem space for the solution
> space pretty fast; I see your note:
>
> > 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.
>
> ... but I don't see any actual examples of those. Can you elaborate?
>
> --
> -- Christophe Pettus
> xof(at)thebuild(dot)com
>
> --
[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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2018-04-15 18:03:49 Re: Proposal: Adding json logging
Previous Message John W Higgins 2018-04-15 17:58:24 Re: Proposal: Adding json logging