11. MFBASE Log¶

11.1. Default logs files¶

MFBASE produces logs files stored in the log directory of the MFBASE root directory.

Logs parameters as log retention, log level are configured in the [log] section of the config/config.ini file in the MFBASE root directory. Check this file for further details.

11.2. PostgreSQL logs files¶

PostgreSQL logs are stored in in the log/psql directory of the MFBASE root directory.

If you need to enable logging of all SQL statements executed by PostgreSQL, you have to change the log_statement setting in the PostgreSQL configuration:

#log_statement = 'none'                 # none, ddl, mod, all

Another way to change the configuration is to issue either SQL ALTER SYSTEM statement, or SQL set_config function, with an PostgreSQL administrative account, e.g. :

ALTER SYSTEM SET log_statement = 'all';

SELECT set_config('log_statement', 'all', false);

When you change the PostgreSQL configuration, in any way, you must reload the configuration. You could use the following:

mfbase.stop
mfbase.start