Where are the PostgreSQL logs on Mac OS X ?
In the mac OS X Homebrew installation the log can be found at:
Another one function
(First one is version < 9.6 and second one is version >= 9.6 of PostgreSQL)
Just execute this query
category IN( 'Reporting and Logging / Where to Log' , 'File Locations')
In my case, it’s in “/Library/PostgreSQL/8.4/data/pg_log”