[SOLVED] Postgresql settings not changing after editing postgresql.conf file. Postgresql 13. Debian 11

Issue

Empirically, it was revealed that the parameters log_min_duration_statement = 0 and logging_collector = on are indeed set in the pg_settings table. But the parameters in the pg_settings table do not react to changes in postgresql.conf. After changing postgresql.conf, postgresql restarted with the systemctl restart postgresql command. In the postgresql.conf file parameter logging_collector = off.

Solution

There are some simple possible mistakes that you could have made:

• edit the wrong postgresql.conf

• restart the wrong server

If you can rule out these explanations, the setting from postgresql.conf must have been overridden somewhere else. Find out where with

SELECT name, setting, source, sourcefile, sourceline
FROM pg_settings
WHERE name IN ('logging_collector', 'log_min_duration_statement');

The last three columns tell you where the setting originates.

Answered By - Laurenz Albe

Answer Checked By - Cary Denson (WPSolving Admin)