Postgres - Enable/Disable query logging

instructions.md

Enable query logging

• Check version, determine which config file to edit

• SELECT version();

• PostgreSQL 12.3 (Ubuntu 12.3-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-10ubuntu2) 9.3.0, 64-bit

• sudo nano /etc/postgresql/12/main/postgresql.conf

• Find REPORTING AND LOGGING section and change following settings

• log_statement = 'all'

• Reload configuration from command line SELECT pg_reload_conf();

• Tail log file tail -f /var/log/postgresql/postgresql-12-main.log

Disable query logging

• Comment out log_statement line
• SELECT pg_reload_conf();