postgres auto_explain : setting log_min_duration doesn't start

Question

postgres 8.4.20

With these settings, the daemon starts :

postgresql.conf

shared_preload_libraries = 'auto_explain'

With these settings, the daemon doesn't start :

postgresql.conf

shared_preload_libraries = 'auto_explain'

auto_explain.log_min_duration = 1000

It is a server with a legacy application, so we cannot upgrade PG. I cannot find documentation of this behaviour / bug...

It aborts too early. I tried with log_destination = 'stderr' and after log_destination = 'syslog' but no output. — Massimo, Commented Mar 7, 2018 at 14:25
Did you set custom_variable_classes = 'auto_explain' in the postgresql.conf file? — jjanes, Commented Mar 8, 2018 at 17:42

Massimo · Accepted Answer · 2018-03-08 08:32:58Z

0

I put also this setting and it solved :

custom_variable_classes = 'auto_explain'

answered Mar 8, 2018 at 8:32

Massimo

1215 bronze badges

Missing that line does produce output to the server log. You should figure out why you can't find the log output, as you will surely run into other problems in the future for which it would be helpful.
– jjanes
Commented Mar 9, 2018 at 21:52

Add a comment |

1 Answer 1