Enable SQL debug mode in PostgreSQL 15.2

Question

I tried to enable full debug mode using this Tutorial

But in PostgreSQL 15.2 configuration file location is changed. Do you know how I can enable full debug mode?

Does this answer your question? Postgres find configuration files in linux, Where does PostgreSQL store configuration/conf files? — Bergi
– Bergi, Commented Mar 31, 2023 at 11:24

Frank Heikens · Accepted Answer · 2023-03-31 11:24:19Z

2

Use the ALTER SYSTEM statements:

ALTER SYSTEM SET log_statement = 'all';

Depending on what you change, you have to use pg_reload_conf() to just reload the configuration or you must stop&start the database cluster.

answered Mar 31, 2023 at 11:24

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

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

2 Comments

What is the default value? Maybe ALTER SYSTEM SET log_statement = 'info';?

The default is ERROR, which means statements causing errors, log messages, fatal errors, or panics will be logged.