Where are the PostgreSQL logs on macOS?

postgresql logging macos
protoboolean picture protoboolean · Apr 1, 2010 · Viewed 54.4k times · Source

I would like to take a look at the PostgreSQL log files to see what my app writes to them but I can't find them.

Any ideas?

Answer

Mikko Ohtamaa picture Mikko Ohtamaa · Jun 20, 2015

On OSX Homebrew installation the log can be found at:

/usr/local/var/log/postgres.log

or for older version of postgres (< 9.6)

/usr/local/var/postgres/server.log

Related questions

How to log PostgreSQL queries?

How to enable logging of all SQL executed by PostgreSQL 8.3? Edited (more info) I changed these lines : log_directory = 'pg_log' log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' log_statement = 'all' And restart PostgreSQL service... but no …

Read More
How can I use a PostgreSQL triggers to store changes (SQL statements and row changes)

Using PostgreSQL triggers, is it possible to record the changes that have happened to a table due to INSERT or UPDATE SQL statements and log them to a file for later execution. This is only to be used temporally so …

Read More
PostgreSQL how to find any changes in the last n-minutes

I am writing a program that syncs PostgreSQL and MS SQL server databases (and adds some changes in this transition). With multi million records, it takes a long time, and loads server pretty bad with select *; it also takes more …

Read More