On MacOS, how to turn on the detailed log of brew installed PostgreSQL¶

On MacOS, I installed PostgreSQL service with brew. Now I want it to log all the executed SQL statements.

Update PostgreSQL configuration¶

Open the file /usr/local/var/postgres/postgresql.conf, and add these lines to it:

log_statement = 'all'
log_directory = '/tmp/pg_log'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
logging_collector = on
log_min_error_statement = error

Please change the log_directory configuration to your own log directory.

Restart service¶

After the configuration, remember to restart the service so that the configuration can take effect.

brew services restart postgresql

This article is originally created by tooli.top. Please indicate the source when reprinting : https://www.tooli.top/posts/pgsql_brew_log