Error in reading Postgres log by pgfouine.php

Question

I have Postgres configuration with LOGFILE defined in the bash script /etc/rc.d/init.d/postgresql by the option -l ${LOGFILE}

Log gives the following output :

2013-06-07 11:28:18 EDT rentgrowLOG: statement: select count(*) from (select * from results limit 1) test
2013-06-07 11:28:18 EDT rentgrowLOG: duration: 0.333 ms

This output is not readable by pgfouine.php – the error is: “pgFouine did not find any valid PostgreSQL log line in your log file:”

I found also that my changes in postgresql.conf do not affect the output at all.

How prepare a Postgres log file readable by pgfouine.php?

What's your log_line_prefix in postgresql.conf and what are the options passed to pgFouine? — Daniel Vérité
– Daniel Vérité, Commented Jun 7, 2013 at 22:09
log_line_prefix = '%t [%p]: [%l-1] ' C:\pgf>\wamp\bin\php\php5.3.13\php.exe pgfouine.php -file postgresql-2013-06-07_182652.log -logtype stderr I do not see that changing the options in the config files changes the output. I could not install php on Linux, so I am using windows — Alex
– Alex, Commented Jun 11, 2013 at 14:39

Community · Accepted Answer · 2017-05-23 12:13:00Z

1

I found also that my changes in postgresql.conf do not affect the output at all.

That's probably the source of the problem. Your log_line_prefix is being ignored. Otherwise, with the prefix set to '%t [%p]: [%l-1] ' as recommended by pgFouine, the log entries would look like this:

2013-06-13 16:38:18 CEST [6203]: [2-1] LOG:  duration: 0.169 ms  statement: select 1;

As to the question: why are the changes to postgresql.conf being ignored? Some typical reasons would be:

Not reloading it after the change, by sending SIGHUP to the postmaster, either directly or through the pg_ctl or service commands.
Editing the wrong file. See: Where are my postgres *.conf files?

edited May 23, 2017 at 12:13

CommunityBot

11 silver badge

answered Jun 13, 2013 at 14:54

Daniel Vérité

62.3k16 gold badges134 silver badges160 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error in reading Postgres log by pgfouine.php

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related