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](https://stackoverflow.com/questions/47790659/postgres-find-configuration-files-in-linux), [Where does PostgreSQL store configuration/conf files?](https://stackoverflow.com/questions/3602450/where-does-postgresql-store-configuration-conf-files) — Bergi, Mar 31 '23 at 11:24

score 2 · Accepted Answer · answered Mar 31 '23 at 11:24

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 '23 at 11:24

Frank Heikens

What is the default value? Maybe `ALTER SYSTEM SET log_statement = 'info';`? – Peter Penzov Apr 02 '23 at 17:16
The default is ERROR, which means statements causing errors, log messages, fatal errors, or panics will be logged. – Frank Heikens Apr 02 '23 at 20:01

1 Answers1