jsonlog logging only some messages?

From: Greg Stark <stark(at)mit(dot)edu>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: jsonlog logging only some messages?
Date: 2018-02-26 17:38:56
Message-ID: CAM-w4HM9vNpYmZWRyztnzmtuH65cow0ef_GKyXYQPX=5PLxP+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I tried loading the jsonlog module from
https://github.com/michaelpq/pg_plugins into Postgres 9.6.

However it seems it resulted in logs only for session log messages but
not any background worker log messages. We have log_checkpoints set
but there were no log messages in the json log about checkpoints. Nor
were there any from autovacuum.

Also I have log_destination set to stderr,cvslog and as I understand
it the jsonlog module effectively overrides the "stderr" output which
goes to the file named *.log (which I find super confusing,
incidentally). But I was expecting to get the csv file as well. We
didn't, we only got the *.log file with the (partial) json logs. Is
there something I'm missing here or is this unexpected?

--
greg

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2018-02-26 18:15:04 Rewrite of pg_dump TAP tests
Previous Message Claudio Freire 2018-02-26 16:44:37 Re: [HACKERS] [PATCH] Vacuum: Update FSM more frequently