Disable / enable postgres query log

postgres-log.md

1. Find the log file

psql -U postgres -c 'SHOW config_file' 

2. Change the settings

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

3. Restart postgresql service

For MacOS

brew services restart postgresql@14

SELECT pg_current_logfile();

/opt/homebrew/var/log/postgres.log

SELECT 
    * 
FROM 
    pg_settings 
WHERE 
    category IN( 'Reporting and Logging / Where to Log' , 'File Locations')
ORDER BY 
    category,
    name;

/opt/homebrew/var/postgresql@14/pg_log

pg_dump -U postgres -h localhost -d mamma_development | gzip > ./mamma_development.sql.gz