From: manish yadav <manishy174@yahoo.co.in>
To: pgsql-admin@lists.postgresql.org, "S.Bob" <sbob@quadratum-braccas.com>
Subject: Re: pgbadger question
Date: Thu, 27 Feb 2020 04:22:06 +0000 (UTC)
Message-ID: <1410727976.946305.1582777326664@mail.yahoo.com> (raw)
In-Reply-To: <2c0a721c-977f-6233-5eed-c77bd0d3fbdb@quadratum-braccas.com>
References: <2c0a721c-977f-6233-5eed-c77bd0d3fbdb@quadratum-braccas.com>
Hi,
Please try with passing parameter log_line_prefix using --prefix
pgbadger --prefix <value in log_line_prefix> -o postgres-Mon.html ./postgres-Mon.log
Note : copy/paste exact value from PostgreSQL.conf file/show all and paste in the command above.
Thanks and Regards,
Manish Yadav
Mobile : +91 8527607945
On Thursday, 27 February 2020, 1:47:43 AM IST, S.Bob <sbob@quadratum-braccas.com> wrote:
All;
Sorry if this is OT:
We have a client that logs all statements with :
log_statement = 'all'
However they also have left log_min_duration_statement disabled:
log_min_duration_statement = -1
When I attempt to parse a report with pgbadger like this:
pgbadger -o postgres-Mon.html ./postgres-Mon.log
It parses zero queries, even though the query data is there, just that
it was logged via log_statement = 'all' instead of via setting
log_min_duration_statement = x
Is there any way to force pgbadger to pick up / reckognize the logges
queries?
Thanks in advance
--
`When you say "I wrote a program that crashed Windows", people just stare at you blankly and say "Hey, I got those with the system, *for free*".' (By Linus Torvalds)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: manishy174@yahoo.co.in, sbob@quadratum-braccas.com
Subject: Re: pgbadger question
In-Reply-To: <1410727976.946305.1582777326664@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox