Re: Proposal: More structured logging - Mailing list pgsql-hackers

From Ronan Dunklau
Subject Re: Proposal: More structured logging
Date
Msg-id 3358218.yRJqF8fxcQ@aivenronan
Whole thread Raw
In response to Re: Proposal: More structured logging  (Ronan Dunklau <ronan.dunklau@aiven.io>)
List pgsql-hackers
Le vendredi 20 août 2021, 11:31:21 CEST Ronan Dunklau a écrit :
> Le jeudi 19 août 2021, 15:04:30 CEST Alvaro Herrera a écrit :
> > On 2021-Aug-13, Ronan Dunklau wrote:
> > > ereport(NOTICE,
> > >
> > >  (errmsg("My log message")),
> > >  (errtag("EMITTER", "MYEXTENSION")),
> > >  (errtag("MSG-ID", "%d", error_message_id))
> > >
> > > );
> >
> > Interesting idea.   I agree this would be useful.
> >
> > > Please find attached a very small POC patch to better demonstrate what I
> > > propose.
> >
> > Seems like a good start.  I think a further step towards a committable
> > patch would include a test module that uses the new tagging
> > functionality.
>
> Please find attached the original patch + a new one adding a test module.
> The test module exposes a function for generating logs with tags, and a log
> hook which format the tags in the DETAIL field for easy regression testing.
>
> Next step would be to emit those tags in the CSV logs. I'm not sure what
> representation they should have though: a nested csv in it's own column ? A
> key => value pairs list similar to hstore ? A json object ?

I opted for a JSON representation in the CSV logs, please find attached v3
which is the same thing as v2 with another patch for CSV log output.

>
> Also we should probably make this available to the client too, but once
> again the format of the tag field needs to be defined. Any opinion ?


--
Ronan Dunklau
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pg_veryfybackup can fail with a valid backup for TLI > 1
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: pg_veryfybackup can fail with a valid backup for TLI > 1